Adding days to an auto populated date in Excel

Closed
Don - Oct 6, 2015 at 01:35 PM
ysantana
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015
- Oct 6, 2015 at 04:21 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Oct 6, 2015 at 01:47 PM
3 days or 3 business days ?
0
ysantana
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015

Oct 6, 2015 at 01:53 PM
3 Business days.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Oct 6, 2015 at 03:03 PM
You can try using Workday function

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

Oct 6, 2015 at 03:53 PM
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
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Oct 6, 2015 at 04:03 PM
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
ysantana
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015

Oct 6, 2015 at 04:21 PM
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