| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add value to a cell based on the calendar?
I would like to create an Earned Leave report for my company. My company
accrues sick time for each employee at a rate of 8 hours per month on exactly the 16th day of each month. Is it possible to create a formula so that the value in the cell increases by "8 hours/month" automatically on the 16th day of each month? It might be a long shot but I figured I'd just ask. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add value to a cell based on the calendar?
=SUMPRODUCT(--(DAY(A1:A100)=16))*8
"LoriKLynn" wrote: I would like to create an Earned Leave report for my company. My company accrues sick time for each employee at a rate of 8 hours per month on exactly the 16th day of each month. Is it possible to create a formula so that the value in the cell increases by "8 hours/month" automatically on the 16th day of each month? It might be a long shot but I figured I'd just ask. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calendar - vlookup based on dates | Excel Worksheet Functions | |||
| split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
| Determine next Saturday in calendar based on date in a cell | New Users to Excel | |||
| Excel should allow calendar based spreadsheet linking. | Excel Worksheet Functions | |||
| Calendar based on varying information/ Pivot Table General | Charts and Charting in Excel | |||
Linear Mode
