- 6 months, 4 weeks ago TekkyParticipant
Hello, How do I calculate the date for every Monday in the year 2017?6 months, 4 weeks ago ExcelbudKeymaster
There are two easy options.
The above formula calculates the first Monday of 2017. This can be changed to any other year. In the cell below, you can add +7 and drag the formula down.
If you know the specific date, you can enter it in a cell and simply take the cell + 7.
I hope this helps.
You must be logged in to reply to this topic.