Need Workday formula explained

[stpeter]

Hi,
A few weeks ago I posted a thread requesting for a formula to return Mondays, except Holidays. Quoting it here:

“I need a formula to return the date for next Monday over a range say A1:A52. So A1 is Monday, January 4, 2016 and A2 is Monday, January 11, 2016. However, I would like the formula to return the first working day after a holiday (specified in a range in another sheet "Holidays", A1:A26.
If it is the next working day and not the Monday, I would like that cell to be highlighted to alert me that it is already a day after the expected Monday return. So a cell would be Tuesday, March 28, and highlighted in yellow.”

This thread was successfully answered with the formula below.

WORKDAY(DATE(2016,1,3)+((ROW()-1)*7),1,Holidays!$A$1:$A$26)

I now need to change the day but can’t understand how the formula works. Also, each time I cut and paste the above formula to another sheet/row, the days/dates change.

Can someone please explain how this formula works so that I can adjust to my needs without posting new threads.

I’m using Excel 2007 and have basic skills so please detail your explanations as much as possible.
My thanks,

I’m uploading the solution file.
SP