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

[@swee8181]

Thanks doc, the first example was great for me

[@gokulkannanramasamy7178]

THANKS .its really healpful to me

[@elvinahuang2171]

thanks for the tips bro

[@lauriecarrigan1735]

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

[@lucaelia4012]

This helpt me a lot man thanks

[@khrihceu2843]

Thank You

[@DavidSantos-wn7sk]

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

[@kjvbible1611]

does not work

[@franchyilyk]

thanks!

[@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!

[@ShaunPaget]

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

[@ShaunPaget]

@@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😐