Date Formula

Steved · Aug 26, 2004

Hello from Steved

I have A date 21-aug-2004
What would be the formula to subtract 28 days please.

Thankyou

JE McGimpsey · Aug 26, 2004

XL stores dates as integral offsets from a base date, so one way:

A1: 21-aug-2004
A2: =A1-28

Format A2 as a date.

NH · Aug 26, 2004

If date is in cell A1
then
=A1-28
and format this cell to date

Trevor Shuttleworth · Aug 26, 2004

Steve

If the date is in B2 then =B2-28 will give you 24-Jul-04

Regards

Trevor

Steved · Aug 26, 2004

Thankyou very much everyone.

Cheers.