Question

Locked

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.

Natalya

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums