Calcuate 2 days prior to TODAY
Dates are just numbers (offsets from January 1, 1900) which have been
formatted to look like humans expect dates to look... so you can do math on
them. The formula you want is simply...
=TODAY()-2
--
Rick (MVP - Excel)
"jmsinner" wrote in message
...
How do you calculate 2 days prior to =TODAY()?
|