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

[mehmetcik]

The Workday function works thus:-

"=WORKDAY( start_date, days, [holidays] )"

where the arguments are as follows:

start_date - The initial date, from which to count the number of workdays.
days - The number of workdays to add onto start_date.
[holidays] - An optional argument, which specifies an array of dates (in addition to weekends) that are not to be counted as working days.

Your formula is

Please Login or Register  to view this content.

In Cell A1 you have this formula:-

Please Login or Register  to view this content.

Which is your reference Date Sunday 3rd Jan and is copied unchanged to all the cells in column A and is therefore important.

Please Login or Register  to view this content.

Adds 7 to your reference date for every row you go down column A

Please Login or Register  to view this content.

Is your list of holidays that the Workday function will ignore.

So back to your Formula

Please Login or Register  to view this content.

This means

Using Sunday 3rd Jan as a reference, adding 7 days each row, and adding one day. [ So Looking at Each Monday from 4th Jan 2016 ]
And ignoring My Holidays Listed in

Please Login or Register  to view this content.

Return the First Workday.

[stpeter]

Thank you Mehmetcik.
I will work on/practice your explanation. It looks pretty clear so I think I will get it :D
I do appreciate the time you put into it.
SP