Master Calendar

[sna]

Hi Dear,

I need your help regarding leave tracking.
I got a file from my friend.
He needs to list down day base on Drop down list Selection : Monday or Sunday and year 2021 as well as by January, February....
he needs to track his subordinate leave.

Thanks

[puriwutpokin]

Creat New RangeName DaysAndWeeks2=ROW(B5:B46)-ROW(B5)
Select B5:B46 Put =DaysAndWeeks2+DATE($B$1,1,1)-WEEKDAY(DATE($B$1,1,1),($B$2="Monday")+1)+1 Press Ctrl+Shift+Enter
A5=LEFT(TEXT(B5,"[$-en]ddd,"),1)
A4=B5

[sna]

Thank but I need to start from beginning of year 2021 not Dec 2019

Thank

[sna]

Hi Dear could you give formula to start from 1 Jan 21 to Dec 21 base on year and month and week start?

Thanks

[snasui]

Please attach the latest file, point to the problem and explain what is the correct result.

[sna]

Here is an updated file with expected Result

Thank you

[puriwutpokin]

Sample Formula B5=IF(N(B4),MAX(B4:B$5)+1,DATE(B$1,COUNTIF(B$4:B4,"Day"),1))

[sna]

Thank you