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

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

Regards,
Fred

"sonia" <sonia@discussions.microsoft.com> wrote in message 
news:63DDCF12-C093-4532-B71C-2FB9112A47B8@microsoft.com...
> 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

"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

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

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

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" <sonia@discussions.microsoft.com> wrote in message 
news:94082B8F-D7B4-43CC-A096-5952BB208B19@microsoft.com...
> 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