Travis via OfficeKB.com schreef:
I'm trying to create a formula and need help or hints on how to do this.
What I would like to do is: in cell A1 have the word PAYDAY appear on certain
days each month for 1 year. I know that with the 'if' formula you can only
have 7 nested 'if' statements. I need a way to have 24 references (2 days a
month). Any help or questions on this is highly appreciated.

Specify the dates on another sheet and make a reference to it with VLOOKUP