View Single Post
  #1   Report Post  
Susan Hayes
 
Posts: n/a
Default 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