I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.
I was have a tendency to track personal financial data in Excel and was recently updating my electricity usage sheet and wanted to set a date column to auto incremement by one month for each row. I did some checking and found that the EDATE function can be used to get the same date of the previous or future months based on the second parameter.
The structure opf the function calls is shown below:
=EDATE(start date, number of months)
For example, if I wanted to add one month to todays date, I would use the following:
=EDATE(Now(), 1)