I really did search, but I'm not sure I knew the correct terms to search for. I hope this is a simple formula that someone can assist me with! Thank you for any help!
In Cell Y1 (merged to AB) the user will select the month from a drop down. (Also, the year is selected from AC1 (merged to AE))
I would like that if a 31 month is selected from this drop down then the #31 will populate in Cell AF2.
Also if Feb is selected it will blank out Cells AE2-AG2. I'm still trying to figure out FEB LY. If Excel doesn't already have this in a calculation somewhere I might just include Feb Leap Year in the drop down.
Again,
Thank you for all your help!!
Bookmarks