Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a function that I can use to turn dates into the end of year or the
beginning of the preceed year and for a period in the future. We have specific "bonus & review" periods which are end of your first calendar year; beginning of 2nd calendar year; and end of 4th calendar year. Ie if I have the date 5/30/2001 I would like it to be able to return: 12/31/2001 (end of year) 1/1/2002 (beginning of 2nd calendar year) 12/31/2004 (end of 4th calendar year) Thanks much!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel NPV initial cost in value1 and first year return in value2? | Excel Worksheet Functions | |||
Vacation Time calculation... HELP! | Excel Discussion (Misc queries) | |||
Lookup returns wrong value | Excel Worksheet Functions | |||
holiday dates | Excel Worksheet Functions | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) |