Format control data - values to be input differently on different tabs

It sounds as if the dates April 11, 2017 and April 13, 2017 should change to May 11, 2017 and May 13, 2017 when May is selected in the control form on the Holiday sheet. If that is the case the formulas for B3 and C3 respectively are:
B3: =DATE(2017,$J2,11)
C3: =DATE(2017,$J2,13)
Let us know if you have any questions.

Originally Posted by JeteMc

It sounds as if the dates April 11, 2017 and April 13, 2017 should change to May 11, 2017 and May 13, 2017 when May is selected in the control form on the Holiday sheet. If that is the case the formulas for B3 and C3 respectively are:
B3: =DATE(2017,$J2,11)
C3: =DATE(2017,$J2,13)
Let us know if you have any questions.

Hi JeteMc,

Unfortunately not. I will explain my request again..

On the format control, on the holiday sheet tab, if i select april, I want to input date for april ONLY: i.e. 01/04/2019 - 10/04/2019. This is 9 days in total for april, which should be calculated on the April 2019 tab

If I select May from the format control on the holiday sheet tab, I want to input a date for May only i.e. 01/05-2019 - 06/05/2019. This is 5 days intotal for may, which shou;d be claculated on the may 2019 tab.

Hope this makes sense! thank you!!