ty this one

=IF(MONTH(A1)=9,DATE(YEAR(A1),MONTH(A1)-9,DAY(A1)),DATE(YEAR(A1),MONTH(A1)-9,DAY(A1)))

please reply if the post is helpfull

regrads

elMedex

"sonia" wrote:

Hi

is there a way to figure out a date 9 months previous to a date?

eg. I have an install date of 12/02/10, is there a way or a formula that can
count back 9 months from that install date? (they need to be weekdays)

thanks very much