Calculating a future date
Closed
Michael
-
Nov 19, 2011 at 08:54 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2011 at 08:35 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2011 at 08:35 PM
Related:
- Calculating a future date
- How to calculate 90 days from date in excel - Guide
- Date calculator app for windows - Download - Calculators
- Calculating 8 processors excel - Guide
- Excel save without calculating - Guide
- Date of birth calculator in words ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 20, 2011 at 01:56 AM
Nov 20, 2011 at 01:56 AM
suppose the date is in A1
use this formula and check
=TEXT(IF(WEEKDAY(A1)>4,A1+11-7,A1+4-weeday(A1)),"mm/d/yy")
use this formula and check
=TEXT(IF(WEEKDAY(A1)>4,A1+11-7,A1+4-weeday(A1)),"mm/d/yy")
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 20, 2011 at 08:35 PM
Nov 20, 2011 at 08:35 PM
sorry that 3 waeks i missed here it is
=TEXT(IF(WEEKDAY(A1)>4,A1+11-7+15,A1+4-weeday(A1)+15),"mm/d/yy")
does this help. if problem try to change that 15 .
=TEXT(IF(WEEKDAY(A1)>4,A1+11-7+15,A1+4-weeday(A1)+15),"mm/d/yy")
does this help. if problem try to change that 15 .
Nov 20, 2011 at 01:31 PM