subtracting 28 days from a date

[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?

 

[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?

Try this formula in cell A2:

=A1-28

Hope this helps / Lars-Åke

 

[Billrpc]

Got it, I knew it was simple, but I still don't know what was wrong.

 

[Teethless mama]

=A1-28