Snasui Excel Forum

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

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

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

Thank

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

Thanks

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

Here is an updated file with expected Result

Thank you

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

Thank you