Adding days to an auto populated date in Excel
Closed
Don
-
6 Oct 2015 à 13:35
ysantana Posts 3 Registration date Tuesday 6 October 2015 Status Member Last seen 6 October 2015 - 6 Oct 2015 à 16:21
ysantana Posts 3 Registration date Tuesday 6 October 2015 Status Member Last seen 6 October 2015 - 6 Oct 2015 à 16:21
Related:
- Workday apk download
- Adding days to a date in excel - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Android auto apk - Download - Other
- Nvidia auto detect - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
6 Oct 2015 à 13:47
6 Oct 2015 à 13:47
3 days or 3 business days ?
ysantana
Posts
3
Registration date
Tuesday 6 October 2015
Status
Member
Last seen
6 October 2015
6 Oct 2015 à 15:53
6 Oct 2015 à 15:53
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
6 Oct 2015 à 16:03
6 Oct 2015 à 16:03
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 6 October 2015
Status
Member
Last seen
6 October 2015
6 Oct 2015 à 16:21
6 Oct 2015 à 16:21
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.
6 Oct 2015 à 13:53
6 Oct 2015 à 15:03
=WORKDAY(TODAY(), 5) would show 5 business days from today