Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc