Day before

[srcasm83]

If I have the date 01-09-09 in cell A1, is there a formula that can produce the day before into a different cell? (01-08-09) And will this work for the beginning/end of each month? For example if the date is 02-01-09, will the formula come up with 01-31-09? Thanks!

 

[c_m]

just use A1-1

 

[Norie]

Wouldn't it just be this?

=A1-1

 

[srcasm83]

Wow... that was easy Thanks!

 

[ThomasB]

Hi

try this formula in cell B1

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

This will work for beginning and end of each month

Rgs

Thomas

 

[c_m]

A1-1 would work for the beginning and the end of the month too