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.