calculate back dates

  • Thread starter Thread starter sonia
  • Start date Start date
S

sonia

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
 
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
 
sorry this is the one is easier

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

the other was a test but is redundant
 
Hi

I'm getting a #VALUE! error, everytime I try it.
I put the formulas in the way explained, but I changed A1 to the cell that i
have the install date in, (as i would change the cell to all the different
install dates, there isn;'t just one install date, there are many.

ANy ideas on this problem??
 
Your most likely problem is your cell doesn't have a date in it, it has
text. You need to convert the text to a date.

To confirm this, simply enter 12/02/10 in your cell. See if that solves your
problem. If it does, then you will need to convert your other cells to
dates.

Regards,
Fred
 
Back
Top