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
ysantana Posts 3 Registration date Tuesday October 6, 2015 Status Member Last seen October 6, 2015 - Oct 6, 2015 at 04:21 PM
Related:
- Adding days to an auto populated date in Excel
- How to calculate 90 days from date in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- How to stop auto refresh in facebook app - Guide
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 6, 2015 at 01:47 PM
Oct 6, 2015 at 01:47 PM
3 days or 3 business days ?
ysantana
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015
Oct 6, 2015 at 03:53 PM
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.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 6, 2015 at 04:03 PM
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) )
then you can have it
=WORKDAY(A5, 3)
if lock date can be null u can have
=if(a5="", "", WORKDAY(A5, 3) )
ysantana
Posts
3
Registration date
Tuesday October 6, 2015
Status
Member
Last seen
October 6, 2015
Oct 6, 2015 at 04:21 PM
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.
Oct 6, 2015 at 01:53 PM
Oct 6, 2015 at 03:03 PM
=WORKDAY(TODAY(), 5) would show 5 business days from today