calculate back dates
 

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

calculate back dates
 

Just use the Date function, as in:
=Date(year(a1),month(a1)-9,day(a1))

Regards,
Fred

"sonia" wrote in message
...
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

calculate back dates
 

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

calculate back dates
 

sorry this is the one is easier

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

the other was a test but is redundant



"Alejandro Medinilla "elMedex"" wrote:

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

calculate back dates
 

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??

"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

calculate back dates
 

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

"sonia" wrote in message
...
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??

"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