If formula. Please help. Thank you in advance.

[pedie]

if i enter cell a2 = date 7/19/2010
I want cell a1 to show me previous date that will be 7/18/2010.

Please advice a formula or a macro otherwise....

Thanks again!
Pedi

 

[HalfAce]

Hi Pedie
In A1, try =A2-1

(Kinda sorry you asked now aren't ya?)

Have a good one.

 

[VoG]

In A1

=A2-1

and format as Date.

 

[pedie]

Thanks Dan...Thanks everyone!!!

Have a great day ahead!

 

[VoG]

You are welcome.

If you want to understand why this works take a look here http://www.cpearson.com/excel/datetime.htm#AddingDates