| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calcuate 2 days prior to TODAY
How do you calculate 2 days prior to =TODAY()?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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()? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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()? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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()? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to filter for Dates prior to Today | Excel Discussion (Misc queries) | |||
| How do count a cell range that include all dates prior to today? | Excel Discussion (Misc queries) | |||
| Countifs of prior years monthly data based on MTD today | Excel Worksheet Functions | |||
| Count Days more than 180 days prior to today | Excel Worksheet Functions | |||
| sum values between today and 6 months prior | Excel Worksheet Functions | |||
Linear Mode
