Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 06:35 AM.


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