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!!
|