Datepicker for 2018 formatting formula help

[JohnGreen2]

Need some Formula help - my datepicker sheet work in 2017 but it doesnt work for 2018. This is the formula thats in it

=DATE(Setting!$B$2,Setting!$E$3,1) on K3 I tried to update it for 2018 but its not working. Any help much appreciated with the formula

K1 value = K3 which show January

K2 value also = K3 which show day of week

Uploading the sheet as I dont get it work -rep given for some help. I want the sheet to show 2018 dates of the year in a calender view which I want to use for a database.

I have changed my date to 1/1/18 too with no effect /which I doubt is the cause ?

The 1 Jan 18 is on a Monday

[than_gold]

In the given sheet missing sheet named called "Setting"...

[JohnGreen2]

In the given sheet missing sheet named called "Setting"...

Thanks than_gold.....here is the setting sheet thanks for your help

[than_gold]

Here you go, check the formula in cell K3 in sheet Database.

[JohnGreen2]

Here you go, check the formula in cell K3 in sheet Database.

Fabulous than_gold thank you so much for your assistance.Let me check quickly

[than_gold]

Happy to help you!!