I am creating a dynamic date-based spreadsheet that always asks, (1) What is the date of the next calendar quarter end after "today", and (2) what is the date three months from the end of "today's" month. I need the dates (e.g. 3/31/11 for the first one and 5/31/11 for the second). How can I do that in excel?
Welcome to the forum.
=EOMONTH(TODAY(), CEILING(MONTH(TODAY()), 3) - MONTH(TODAY()))
=EOMONTH(TODAY(), 3)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks