Dates within "IF" statements
Posted by Robert Dorr on April 21, 2001 2:29 AM
I am having problems with the syntax for the use of dates within "If" statements.
I have twelve columns, with the column headers comprised of a EDATE() function in the format mmm-yy.
I wish to reference these columns with a nested "If" statement to the effect:
=IF(C1=April, ......,if(C1=July,.....,If(C1=October,.....,....))) "C1" in this example is the column header in the EDATE()format described above.
I do not know how to reference the month ("March") in the formula. Everything I try does not work!
Thanks for your previous help!..... Robert Dorr