Excel inventory Sheet for workday month

G

Guest

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
 
G

Guest

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

function to fill all days of month to end of month 11
workday with month functions 5
Calculating monthly start date with a start date 3
How to shift a weekend date to the last or next workday 2
Using workday function to populate schedule 2
Workday Function in Excel 2007 2
Excel Workday Function with another function 2
Workdays not working as expected 3

Top