Month Format summation

[Shirley]

Hi. I have this excel spreadsheet as the followings :
Column A1 = 3 (in number)
Column B1 = 1/4/2006
C1 = 1/1/2006 (answer)

I need to find out what is the previous 3 months before 1/4/2006 in C1. Do
I have to format Column A1 (3) in the month format as it is just a number.

Thank you in Advance !!

[Gary]

in C1, write

=B1-A1

it should work.

"Shirley" <[email protected]> wrote in message
news:[email protected]...
> Hi. I have this excel spreadsheet as the followings :
> Column A1 = 3 (in number)
> Column B1 = 1/4/2006
> C1 = 1/1/2006 (answer)
>
> I need to find out what is the previous 3 months before 1/4/2006 in C1.
> Do
> I have to format Column A1 (3) in the month format as it is just a number.
>
> Thank you in Advance !!