Question

Locked

MS Excel Date Conversion

By nyakovleva ·
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 conversation is currently closed to new comments.

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

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums