Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vacation Accrual
I have read through the past posts and havent found exactly what I am looking
for. I need to have a formula that will tell me how many months an employee has worked after his anniversary THIS year, up to his anniversary NEXT year. I am able to make a formula that will calculate for this year, but when the year changes, it messes up. EX. Ann. date of 10/1/08. On 11/1/08 it should say "1", on 12/1/08 is should say "2", on 1/1/09 is should say "3", etc.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vacation accrual formula | Excel Discussion (Misc queries) | |||
Vacation accrual Spreadsheet | Excel Discussion (Misc queries) | |||
Vacation/Sick accrual | Excel Worksheet Functions | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions |