Validation Links

[Guest]

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

 

[Ardus Petus]

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

HTH

 

[Guest]

thank you for your help, but im getting a value error???

 

[Ardus Petus]

Where are your month and year cells?

--
AP

thank you for your help, but im getting a value error???

 

[Ardus Petus]

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

 

[Guest]

month is C6 and year is C7....currently i have the validation list as the
month i.e. Jan Feb Mar???

 

[Ardus Petus]

Try turning your validation list into 1,2,3,...12