Calcuate 2 days prior to TODAY
 

How do you calculate 2 days prior to =TODAY()?

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()?

Calcuate 2 days prior to TODAY
 

No. I'm using excel/vba to fill web forms. The problem is when the IE
window loses it's active status(by user clicking on another window, the
filling is redirected to the other window.

Dennis


"jmsinner" wrote in message
...
How do you calculate 2 days prior to =TODAY()?

Calcuate 2 days prior to TODAY
 

'VBA
Date-2

'Worksheet function
=TODAY()-2

If this post helps click Yes
---------------
Jacob Skaria


"jmsinner" wrote:

How do you calculate 2 days prior to =TODAY()?

Calcuate 2 days prior to TODAY
 

On Sun, 19 Jul 2009 09:40:01 -0700, jmsinner
wrote:

How do you calculate 2 days prior to =TODAY()?

=today()-2

--ron