MS Excel Date Conversion

By nyakovleva ·
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums