Calculated Column Formula

Question

I have 2 Drop Downs

1. Month
2. Date

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.

Answer 1

This would not be possible as a calculated column given that you want to control the users input. You may be able to do it with list level validation but that would only tell the user they had entered an incorrect Date when they tried to save the form.

jQuery is probably your best option where you can adjust the Date drop-down choices based on the selected Month.

However, it may make more sense to ask why you are taking this approach and recreating what the Date field does by default? If you want to get the Date and Month values separately then I would use calculated columns to get these from a Date column. eg

=TEXT([MyDate],"dd")

Answer 2

If you are allowed to use InfoPath, you can filter dropdown items by month column dropdown using rules.