Excel inventory Sheet for workday month

M

Monique

I need an inventory sheet that uses the workday, holiday and month formula
and I can't get it to work.

A1 has the date

b1:m1 have workday weeks minus holidays.
a39:m39 continues dates until the month ends. Blank cells appear in shorter
months.

I found a formula for the blank cells:
=IF(A1="",A1,IF(MONTH(A1+1)=MONTH(A1),A1+1,""))

But I don't know how to combine it with the other factors.

Can anyone help me?

Thanks in advance!
Monique
 
M

Monique

Monique said:
I need an inventory sheet that uses the workday, holiday and month formula
and I can't get it to work.

A1 has the date

b1:m1 have workday weeks minus holidays.
a39:m39 continues dates until the month ends. Blank cells appear in shorter
months.

I found a formula for the blank cells:
=IF(A1="",A1,IF(MONTH(A1+1)=MONTH(A1),A1+1,""))

But I don't know how to combine it with the other factors.

Can anyone help me?

Thanks in advance!
Monique
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating monthly start date with a start date 3
workday with month functions 5
function to fill all days of month to end of month 11
WORKDAY resulting in #VALUE error 4
Alternative to WORKDAY when Analysis ToolPak not loaded 9
Using workday function to populate schedule 2
How to shift a weekend date to the last or next workday 2
Workday function returns the wrong date when the duration is 5 day 5

Top