Microsoft Excel – finding a date exactly two months after another date

To find a date exactly two months after another date, you can use the EDATE function. This returns the serial number of the date that is the indicated number of months before or after the start date.

Two months from now

Two months from now

Now, on the Home tab, in the Number group, click the dropdown where it says General and select Short Date. You will have the required dates.

Microsoft Excel - finding a date exactly two months after another date

Find out more about our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.

Leave a Reply

Your email address will not be published. Required fields are marked *