Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use date for calculating values in other cells
I want to include the date in the "If" statement for calculating values in
other cells. Example: If the start date is after 1/1/1999, then A-B. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use date for calculating values in other cells
On Oct 17, 10:03*am, Bamboozled
wrote: I want to include the date in the "If" statement for calculating values in other cells. Example: *If the start date is after 1/1/1999, then A-B. * If the start date is in c1, would this work? =if(c11/1/1999,a1-b1,"") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use date for calculating values in other cells
On Oct 17, 12:03*pm, Bamboozled
wrote: I want to include the date in the "If" statement for calculating values in other cells. Example: *If the start date is after 1/1/1999, then A-B. * A date in Excel is just a number formatted to look like a date. So if you know the number, you can use greater than or less than just like any other number. 1/1/1999 is actually 36161. Or you can put your control date in another cell (B1 below) and just reference it. Something like: =IF(A136161,A2-B2) =IF(A1B1,A2-B2) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore blank cells when calculating date for If, Then function | Excel Worksheet Functions | |||
calculating date/time with blank cells | Excel Discussion (Misc queries) | |||
How do I make a formula calculating all cells after a certain date | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating current age from 2 date cells | Excel Worksheet Functions |