Question Locked

MS Excel Date Conversion

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

This discussion is closed to new replies.