Excel Formula: Get every Monday of the year automatically (or any weekday) - Doctor Excel

⚡ Download the Excel file (#063) excelsior-trai...
👇 All bonus info below
Doctor Excel shows you how to calculate every monday of the week automatically.
You will learn which formulas to use and how to adapt the formula for any day of the week
⚡ Download the Excel file (#063) excelsior-trai...
#doctorexcel #learnexcel #exceltraining

[@swee8181]

Thanks doc, the first example was great for me

[@taylorfusion]

How would you do this if you wanted all Mondays of the year as column headers, though?

[@gokulkannanramasamy7178]

THANKS .its really healpful to me

[@elvinahuang2171]

thanks for the tips bro

[@lucaelia4012]

This helpt me a lot man thanks

[@khrihceu2843]

Thank You

[@kjvbible1611]

does not work

[@franchyilyk]

thanks!

[@DavidSantos-wn7sk]

How the year 1900 become 2020. What did you click? Sorry I didn't get it. huhu

[@lauriecarrigan1735]

I tried the =E2+7 and got a Value Error.

[@xclusive14119]

I am really struggling!! I’m trying to create a register In Excel and all I need is to have every Monday and Thursday dates next to each other going down from A2 onwards and then then have the names of people going across from B1, c1 etc onwards can anyone help me!!!! What is the formulas I need. I’m really finding it hard! I’m not an expert with Excel, just a beginner.

[@xclusive14119]

So basically for the dates to plus 4 days each time. Monday-Thursday!

[@user-zf4qs2jy3n]

I would like the date on my spread sheet to automatically add 7 days to my date cell every 7 days. Is that possible?

[@msbeautifulcore8881]

Yes with formula =row+3

[@user-zf4qs2jy3n]

@@msbeautifulcore8881 da so simple. Thank you

[@Charly71112]

does not work at all!!!! be careful with the file may have a virus...

[@missc541]

You completely lost me in the 2nd example thats far too long i switched off. The first way was better. Thanks.

[@1.....279]

Man is so confusing p😐