![]() |
#1
|
|||
|
|||
![]() I have a spreadsheet that I use to keep track of quarterly reports, generated off of a different fixed date for each series of dates. Currently, I am calculating the dates by the number of days (90, 180, 270, etc.), but this doesn't allow for the extra 5 (or in this year's case, 6) days in the calendar. Is there a month function in the formulas that can calculate this? For example, if the fixed date is 10/19/2015, I would need to populate the cells with 01/19/2016, 4/19/2016, and 7/19/2016. Please note that I do not need to calculate the difference between two dates (there seem to be a million posts about that), but I need to populate cells with quarterly dates based off of the fixed date. Thanks for any help! Last edited by Artboy34; 01-20-2016 at 08:14 AM. Reason: Update |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
Excel Formula Showing Revenue Recognition Based on Days and Months | stratcat | Excel | 4 | 03-16-2014 10:09 AM |
Calculating 6.5hr work days | altja | Project | 3 | 02-10-2014 03:11 PM |
![]() |
hannu | Excel | 6 | 02-14-2013 09:21 PM |
![]() |
Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |