Maybe your month value is text (like "January", not 1)

--
AP

"mq" a écrit dans le message de news:
...
thank you for your help, but im getting a value error???

"Ardus Petus" wrote:

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