#1
|
|||
|
|||
Calculating Quarterly Dates by Months not Days
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 |
#2
|
|||
|
|||
Do you mean something like this!
In A1: 19/10/2015. In B1 put the following formula and copy across 3 columns. =EDATE($A1,COLUMNS($B1:B1)*3) |
#3
|
|||
|
|||
Hold the phone. It did work when I put it in the right cell. I just need to figure out how to calculate the dates in reverse. BUt thanks so much for putting me on the right path!
Last edited by Artboy34; 01-27-2016 at 11:22 AM. Reason: My own stupidity! |
#4
|
|||
|
|||
Hi
For reverse. =EDATE($A1,COLUMNS(B1:$D3)*3) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
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 |
Converting serial number to years, months and days | hannu | Excel | 6 | 02-14-2013 09:21 PM |
Calculating dates | Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |