Thread: [Solved] Calculating Quarterly Dates by Months not Days
View Single Post
 
Old 01-20-2016, 11:03 AM
Kevin@Radstock Kevin@Radstock is offline Windows 10 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