Hello and Thank you for replying to my question.

I would like to use this code; =IF(AND('Monthly
Totals'!L8="February",'Monthly Totals'!O8=2012),29,28)
with the exception that is looks up these years 2012, 2016, 2020, 2024, 2028

I am using 31 sheets (1 sheet per day), and the code you provided will place
30 or 31 on sheet 29 if any other month is selected.

-Bad

"Ron Coderre" wrote:

With
A2: (a month name....eg February)
B2: (a year........eg 2012)
This formula returns the last day of that month:
C2: =MAX(DAY(DATEVALUE("28-"&A2&"-"&B2)+{0,1,2,3}))

or...slightly shorter
C2: =MAX(DAY(("28-"&A2&"-"&B2)+{0,1,2,3}))

In the above examples, the formulas return: 29

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"BadBoy" wrote in message
...
Hello,

The first formula below checks to see if the word February is in one cell
and the year 2012 in another and if so, will place the number 29 in
another
cell for me and if not, 28.

=IF(AND('Monthly Totals'!L8="February",'Monthly Totals'!O8=2012),29,28)

I am looking to create a formula that will look for the word February in
one
cell and one these following years. Not just 2012.
2012, 2016, 2020, 2024, 2028

If February has been selected from a drop window and as well, one of those
years from another drop window, I wish the program to know that someone
has
selected a leap year and will place the date number 29 in a cell.
Otherwise,
the number 28.

This formula works well but it only checks for the year 2012.
=IF(AND('Monthly Totals'!L8="February",'Monthly Totals'!O8=2012),29,28)

This formula does not work.
=IF(AND('Monthly Totals'!L8="February",'Monthly
Totals'!O8={2012,2016,2020,2024,2028}),29,28)

Thank you in advance for any help you may have to offer.

-Bad