Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2016, 08:06 AM
Artboy34 Artboy34 is offline Calculating Quarterly Dates by Months not Days Windows 8 Calculating Quarterly Dates by Months not Days Office 2016
Novice
Calculating Quarterly Dates by Months not Days
 
Join Date: Jan 2016
Posts: 2
Artboy34 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-20-2016, 11:03 AM
Kevin@Radstock Kevin@Radstock is offline Calculating Quarterly Dates by Months not Days Windows 10 Calculating Quarterly Dates by Months not Days Office 2016
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

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)
Reply With Quote
  #3  
Old 01-27-2016, 11:15 AM
Artboy34 Artboy34 is offline Calculating Quarterly Dates by Months not Days Windows 8 Calculating Quarterly Dates by Months not Days Office 2016
Novice
Calculating Quarterly Dates by Months not Days
 
Join Date: Jan 2016
Posts: 2
Artboy34 is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 01-28-2016, 09:47 AM
Kevin@Radstock Kevin@Radstock is offline Calculating Quarterly Dates by Months not Days Windows 10 Calculating Quarterly Dates by Months not Days Office 2016
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi

For reverse.

=EDATE($A1,COLUMNS(B1:$D3)*3)
Reply With Quote
Reply

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
Calculating Quarterly Dates by Months not Days Converting serial number to years, months and days hannu Excel 6 02-14-2013 09:21 PM
Calculating Quarterly Dates by Months not Days Calculating dates Daria11 Word VBA 1 06-08-2011 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft