Prev: Formulas in a criteria area
Next: Sports team assignment
From: Fred Smith on 23 Mar 2010 11:19
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(a)discussions.microsoft.com> wrote in message
news:94082B8F-D7B4-43CC-A096-5952BB208B19(a)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

First  |  Prev  | 
Pages: 1 2
Prev: Formulas in a criteria area
Next: Sports team assignment