How to calculate consecutive Saturdays or any days of a month | Calculate nth day of any week

In this video, you will learn how to calculate the consecutive days of any month.
You may be interested to find out the all Mondays , Tuesday, Wednesday or any day in the month.
#day #weekday #Excel #tipsandtricks
IN order to calculate you will be using the following formula:
A7-DAY(A7)+1+C7*7-WEEKDAY(A7-DAY(A7)+7-B7)
Keep watching, Keep Learning

[@ArtiSharma-pr2ud]

I saw this video 4 times, initially were not able to understand A7-day(A7)+1+C7*7 formula, (what result it was fetching) but while watching again and again, got understood, were missing your live class, And the video is as usual awesome like you Madam, thank you :) 😊

[@karpagamexcelprime]

Wow... That's great Arti

[@norpabs2574]

how the (-weekday(A7-Day(A7)+7+B7) was derived?