MS Excel Date Conversion - TechRepublic
Question
August 1, 2008 at 10:47 AM
nyakovleva

MS Excel Date Conversion

by nyakovleva . Updated 17 years, 12 months ago

How to convert in Excel any Date to the 1st of subsequent quarter folloing this Date?
For example:
2/5/2008 => 4/1/2008
5/3/2007 => 7/1/2007
8/2/1999 => 10/1/1999
12/5/2008 => 1/1/2009

I need this to calculate the Effective Date of payment based on the anniversary date after certain Years in Service.
Thank you for help in advance.

Natalya

This discussion is locked

All Comments