**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I have a schedule I'm doing with formulas to add workdays (across rows) to a start date column. I would like to write the equation like this:
=ifError((workday(b2,1) = cell above, [value of cell above + 1]
Help me form this correctly to get the (value of target cell) = (1 more than the value from the cell above) IF the target cell value started equal to the cell above.

Solved by M. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
09/08/2017 - 02:19

Welcome to GotitPro!

User
09/08/2017 - 02:19

no thats it

User
09/08/2017 - 02:19

can i show you on the template?

Excelchat Expert
09/08/2017 - 02:19

Can you please provide sample data ?

User
09/08/2017 - 02:19

yes

Excelchat Expert
09/08/2017 - 02:20

Thank you

User
09/08/2017 - 02:24

i would like columns C and on to yield dates that do not repeat. only the move out date can repeat

User
09/08/2017 - 02:26

holy crap that was wise as f@#$

Excelchat Expert
09/08/2017 - 02:27

Now we can continue into the explanation step of this session. I am going to perform the following:

User
09/08/2017 - 02:27

lemme ask you. will this account only for workdays? is that something that could be possible?

Excelchat Expert
09/08/2017 - 02:27

I used Month and Year from Column B

Excelchat Expert
09/08/2017 - 02:28

then added a day

Excelchat Expert
09/08/2017 - 02:28

You want to add workdays only ?

User
09/08/2017 - 02:28

if it could be written in =workday(,) then it would not need any more tweeking. its a schedule for subcontracting companies m-f 8-5

User
09/08/2017 - 02:29

yes please. that would rule!!!

User
09/08/2017 - 02:29

i have to say this is the best resouce i have ever discovered! thank you for hosting these lessons

Excelchat Expert
09/08/2017 - 02:33

Please check

Excelchat Expert
09/08/2017 - 02:35

I’ve completed the solution, take a look if you would like. We can now continue to the discussion stage and I can answer any questions you may have with the solution I provided.

User
09/08/2017 - 02:35

the dates will not be falling in the order provided. they will be dynamically input to that column

Excelchat Expert
09/08/2017 - 02:36

Sorry, please explain

User
09/08/2017 - 02:36

the build point has to be the linear move out date. and it needs to pivot on to the value of the cell above. maybe like this.if=value of cell above add 1

User
09/08/2017 - 02:37

only when the move out date justifies the value of the target cell

User
09/08/2017 - 02:37

not the cell above

Excelchat Expert
09/08/2017 - 02:37

it is based on value of cell above

Excelchat Expert
09/08/2017 - 02:37

c2 is based on value of B2

Excelchat Expert
09/08/2017 - 02:38

sorry c3 is based on vlaue of C2

Excelchat Expert
09/08/2017 - 02:38

Timer is running out

User
09/08/2017 - 02:38

=if(workday(b2,1) = c2-1), c2+1

Excelchat Expert
09/08/2017 - 02:38

Please repost session statting expert_AS

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*