Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel inventory Sheet for workday month
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel inventory Sheet for workday month
"Monique" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory Sheet | Excel Discussion (Misc queries) | |||
How do I build a excel sheet that counts item in an inventory | Excel Worksheet Functions | |||
Inventory Sheet | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Inventory Wash-Out sheet | Excel Worksheet Functions |