Good day friends.
Please I have a drop down list that contains the months of the year from Jan-Dec. I also have another cell say A1 where I am to indicate the number of days in the month chosen from the drop down list. What I want is if I choose Jan, March, May, July, August, October and Dec, A1 will show 31 as the number of days. If I choose April, June, September and November, A1 changes to 30. Finally, if I choose February, A1 changes to 28 or 29 as the case may be. Please I need help to sort this out.
Thanks.