Adding days to an auto populated date in Excel

Closed
Report
-
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015
-
Hello,

I want to add 3 business days to a auto populated date in another field. So for example. B1 will have the auto date (Based on a system entry). C1 should have a date that is 3 business days from the B1 date. Can you assist?


3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
3 days or 3 business days ?
0
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015

3 Business days.
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can try using Workday function

=WORKDAY(TODAY(), 5) would show 5 business days from today
0
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015

Thank you! I am sooo close! I changed the 5 to a 3 since I need it to be 3 business days from the Lock date (Which varies). Because the Lock date can be any day in the calendar year and not Today, I am trying to now make that happen with out getting an error.
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
then replace with the lock date. lets say lock date is in cell a5
then you can have it
=WORKDAY(A5, 3)

if lock date can be null u can have

=if(a5="", "", WORKDAY(A5, 3) )
0
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015

That worked! For one entry. Now I need to have all of the different dates in that A column to give that 3 day result.
0