| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula to calculate whether date has passed
What formula can I use that will insert "Yes" if the date in cell A1 is after
the date in cell A2, for example. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula to calculate whether date has passed
=IF(A1A2,"Yes","No")
Dave -- Brevity is the soul of wit. "Janelle Lister" wrote: What formula can I use that will insert "Yes" if the date in cell A1 is after the date in cell A2, for example. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula to calculate whether date has passed
Thank you, but I'm afraid I'm still having trouble. The formula is returning
an incorrect response. Does it change the IF formula if cell A2 also contains a formula? Cell A1 has a value of January 1, 2007. Cell A2 is the formula =TODAY(). Today is October 18, 2006 and the formula below returns the result Yes. "Dave F" wrote: =IF(A1A2,"Yes","No") Dave -- Brevity is the soul of wit. "Janelle Lister" wrote: What formula can I use that will insert "Yes" if the date in cell A1 is after the date in cell A2, for example. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula to calculate whether date has passed
Formula is calculating correctly. 1/1/2007 is after 10/18/2006.
Dave -- Brevity is the soul of wit. "Janelle Lister" wrote: Thank you, but I'm afraid I'm still having trouble. The formula is returning an incorrect response. Does it change the IF formula if cell A2 also contains a formula? Cell A1 has a value of January 1, 2007. Cell A2 is the formula =TODAY(). Today is October 18, 2006 and the formula below returns the result Yes. "Dave F" wrote: =IF(A1A2,"Yes","No") Dave -- Brevity is the soul of wit. "Janelle Lister" wrote: What formula can I use that will insert "Yes" if the date in cell A1 is after the date in cell A2, for example. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula to calculate whether date has passed
Excel considers the later date to be larger, i.e. A1 = 1/1/2007, A2 =
10/18/2006 therefore A1 is greter than () A2. So 'Yes' is returned. "Dave F" wrote: Formula is calculating correctly. 1/1/2007 is after 10/18/2006. Dave -- Brevity is the soul of wit. "Janelle Lister" wrote: Thank you, but I'm afraid I'm still having trouble. The formula is returning an incorrect response. Does it change the IF formula if cell A2 also contains a formula? Cell A1 has a value of January 1, 2007. Cell A2 is the formula =TODAY(). Today is October 18, 2006 and the formula below returns the result Yes. "Dave F" wrote: =IF(A1A2,"Yes","No") Dave -- Brevity is the soul of wit. "Janelle Lister" wrote: What formula can I use that will insert "Yes" if the date in cell A1 is after the date in cell A2, for example. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| formula for filtering and a defaulting date | Excel Worksheet Functions | |||
| What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions | |||
Hybrid Mode
