| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I use a date in an IF/AND statement?
Trying to formulate =IF(c2 01/31/05, 1,"2") Is there a different date
format to use? Thank you in advance for any help. |
|
#2
|
|||
|
|||
|
Hi,
Try this: =2-(C2VALUE("01/31/05")) or =2-(C2DATEVALUE("01/31/05")) or =2-(C2DATE(2005,1,31)) or =IF(C2DATE(2005,1,31),1,2) etc. Regards, KL "gsmith" wrote in message ... Trying to formulate =IF(c2 01/31/05, 1,"2") Is there a different date format to use? Thank you in advance for any help. |
|
#3
|
|||
|
|||
|
Yahoo - that was exactly what I needed. Thank you KL!!
"KL" wrote: Hi, Try this: =2-(C2VALUE("01/31/05")) or =2-(C2DATEVALUE("01/31/05")) or =2-(C2DATE(2005,1,31)) or =IF(C2DATE(2005,1,31),1,2) etc. Regards, KL "gsmith" wrote in message ... Trying to formulate =IF(c2 01/31/05, 1,"2") Is there a different date format to use? Thank you in advance for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
