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?