subtracting 28 days from a date

B

Billrpc

I know this is simple, but I am at a loss...A1 is a given date...A2 needs to
be 28 days prior. Formula please?
 
L

Lars-Åke Aspelin

I know this is simple, but I am at a loss...A1 is a given date...A2 needs to
be 28 days prior. Formula please?
Click to expand...

Try this formula in cell A2:

=A1-28

Hope this helps / Lars-Åke
 
Top