Saturday, 24 January 2015

Microsoft Excel Alternative Formula for Monthly Date Addition

Microsoft Excel Alternative Formula for Monthly Date Addition

Create start date cell, in this example = A9, format as date.
Create the amount of columns needed i.e. 4 if quartet stats required and also format cells as date.

In first column, =sum(A9+90)
In second column cell type =sum(A9+181)
In third column cell type =sum(A9+273)
In fourth column cell type =sum(A9+365)

This should give you the same day in each column but quarterly months from original start date.