| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do I write the date in an if statement
Hello I'm trying to write the date (eg., 21-Mar-05, or any other variation), using contatination within an if statement
Here is a sample =IF(A1="scenario1","(2) enter the correct post dated process date in the ""PROC"" field"&" "&"c2","") where "c2" would contain the date, would appear as shown below: (2) enter the correct post dated process date in the "PROC" field 21-Mar-05 Is this possible? Thank you Susan |
|
#2
|
|||
|
|||
|
Hi!
Try this: =IF(A1="scenario1","(2) enter the correct post dated process date in the ""PROC"" field "&TEXT(C2,"dd-mm-yy"),"") Biff "Susan Hayes" wrote in message ... Hello I'm trying to write the date (eg., 21-Mar-05, or any other variation), using contatination within an if statement Here is a sample =IF(A1="scenario1","(2) enter the correct post dated process date in the ""PROC"" field"&" "&"c2","") where "c2" would contain the date, would appear as shown below: (2) enter the correct post dated process date in the "PROC" field 21-Mar-05 Is this possible? Thank you Susan |
| 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 | |||
| How do I get an IF statement to pull a date range?? | Excel Worksheet Functions | |||
| If statement with date | Excel Discussion (Misc queries) | |||
| Using date function in an if statement | Excel Worksheet Functions | |||
| Date in an IF statement | Excel Worksheet Functions | |||
Hybrid Mode
