how do I write the date in an if statement

S

Susan Hayes

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
 
B

Biff

Hi!

Try this:

=IF(A1="scenario1","(2) enter the correct post dated process date in the
""PROC"" field "&TEXT(C2,"dd-mm-yy"),"")

Biff
 
Top