| 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 | |||
Linear Mode
