Date Issue

[shr667]

I have a series of 186 dates that I need to subtract 6 months from.
They are various dates and I can not seem to find a way to do it easily.
Does anyone have a suggestion.

Thanks

[jeffs12]

The EDATE function should do what you want.

Below copied from the online help...

EDATE
The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation.
Syntax
EDATE(StartDate; Months)
StartDate is a date.
Months is the number of months before (negative) or after (positive) the start date.
Example
What date is one month prior to 3.31.2001?
=EDATE(3.31.2001;-1) returns 2.28.2001.

[shr667]

Thank you, saved me a lot of work.
Is it possible to do the year also?

[Hagar Delest]

I guess that if you combine 12 as months and Year() you should get what you want.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the edit button if your issue has been fixed.