Calcuate 2 days prior to TODAY

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:345313F0-7E3C-423E-A351-(E-Mail Removed)...
> How do you calculate 2 days prior to =TODAY()?
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:345313F0-7E3C-423E-A351-(E-Mail Removed)...
> How do you calculate 2 days prior to =TODAY()?
>

's Computer Specifications

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

's Computer Specifications

On Sun, 19 Jul 2009 09:40:01 -0700, jmsinner
<(E-Mail Removed)> wrote:

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

=today()-2

--ron

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Days more than 180 days prior to today	Gregory Day	Microsoft Excel Worksheet Functions	4	28th Mar 2008 10:16 PM
How do I calculate days to the calendar eg. today + 65 days =?	LMH	Microsoft Word Document Management	2	26th Mar 2008 06:26 AM
outlook today view...all days should be listed (no skipping days)	=?Utf-8?B?T3V0bG9vayBUb2RheSBGb3JtYXQ=?=	Microsoft Outlook Discussion	0	28th Feb 2006 11:36 PM
sum values between today and 6 months prior	=?Utf-8?B?UWFzcGVj?=	Microsoft Excel Worksheet Functions	3	19th Jan 2005 08:17 PM
How can I create a field to calcuate Number of days elapsed from d	=?Utf-8?B?S2FyZW4gV2lsbGlhbXM=?=	Microsoft Frontpage	2	11th Nov 2004 04:42 PM