With month in A1, year in B1:
=DAY(DATE(B1,A1+1,0))

HTH
--
AP

"mq" a écrit dans le message de news:
...
I have created two drop down lists in excel: one for the months of the year
and the other for years 1990-2015. I am trying to have another cell linked
to
these two selections with the result being the total number of days in the
month selected based on the year selected...Does anyone have a solution to
this? Thanks alot