MS Excel Date Conversion - TechRepublic
Question
July 16, 2008 at 09:35 AM
nyakovleva

MS Excel Date Conversion

by nyakovleva . Updated 18 years ago

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

This discussion is locked

All Comments