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

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