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)
Click to show/hide the Excel Snippets Series Index
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.