Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default End of Year

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel NPV initial cost in value1 and first year return in value2? Johanna Excel Worksheet Functions 3 September 12th 06 11:12 PM
Vacation Time calculation... HELP! brubru Excel Discussion (Misc queries) 1 July 22nd 06 10:10 PM
Lookup returns wrong value motorjobs Excel Worksheet Functions 5 June 21st 06 11:49 PM
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"