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
 

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

Top