By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Display dates at quarterly intervals from a specified date

P: 1
If the start date is say Apri 20th, the next quarter would fall on July 20th and then on Oct. 20th, Jan 20th and so on.
But if the start date is Nov.30th, the next quarter would fall on 28th (or 29th) February. Fine. But the quarter thereafter instead of falling on May 31st, falls on May 28th (or 29th) and all subsequent quarters fall on 28th(or 29th). The same error crops up in monthly intervals.
How to rectify this. I want the dates as Nov.30th, 28(or 29)Feb.,May 31st, Aug.31st and so on.
This is for the purpose of calculating quarterly interest on fixed deposits.
Thanking you in advance.
Mar 24 '17 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.