I am trying to have a single cell (A1) show the word "payday" when 2
different days each month comes around (the 1st and 15th) for the whole year.
I have a few months already set up using 'if/and' statements like this:
A1 =(IF(AND(A200=1,B200=13),"P * A * Y * D * A * Y",IF
(AND(A201=2,B201=1),"P * A * Y * D * A * Y",IF(AND(A202=2,B202=15),
"P * A * Y * D * A * Y",IF(AND(A203=3,B202=1),"P * A * Y * D
* A * Y",IF(AND(A204=3,B204=15),"P * A * Y * D * A * Y",IF(AND
(A205=3,B205=31),"P * A * Y * D * A * Y",IF(AND(A206=4,B206=14),"P
* A * Y * D * A * Y","")))))))).

A200-206 gives the month 1-12 for the year.
B200-206 gives the day of each month.

Being fairly new to this, is there an easier way to achieve this result? If
so please let me know, and if you have any questions on this posting let me
know.

Thanks for any help,
T_Sr

--
Message posted via http://www.officekb.com