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.
Excel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.
ReplyDelete