Question Locked
MS Excel Date Conversion
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What is the formula might be in order to convert any Date to the 1st of the subsequent quarter following this Date?
For example:
2/5/2008 => 4/1/2008
5/3/2008=> 7/1/2008
8/2/2008=> 9/1/2008
12/5/2008=>1/1/2009
I need this to calculate the Effective Date based on the anniversary date after certain years in service.
Thank you.
Natalya