I have 2 Drop Downs
In Month Column dropdown I am displaying
Jan, Feb, March, April, May, June, July, August, Sep, Oct, Nov, Dec
In Date Column dropdown I am Displaying
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15....31
How can I do a Calulated Formula where in:
If Jan is selected in Month dropdown then Date dropdown should have 31 days.
If Feb is selected in Month dropdown then Date dropdown should display 28 or 29 days.
and so on
Can you please guide me how to achieve this in a List Calculated Column.