Calculating Quarterly Dates by Months not Days

		Microsoft Office Forums > Microsoft Excel > Excel
Calculating Quarterly Dates by Months not Days

01-20-2016, 11:03 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 Calculating Quarterly Dates by Months not Days

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 AM.