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
|