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
- Calculating 8 processors excel - Guide
- Date calculator app for windows - Download - Calculators
- Dear team whatsapp, my whatsapp account is still closed, a lot of my work is on hold due to the account being closed. i have requested you many times, but you are not listening. you are requested to remove the restriction placed on my account. i have been very troubled for a long time. i have read all your terms and conditions carefully and i will not make any mistake in future. please unbanned my whatsapp account which number given below- my mobile number +91xxxxxxxxx - WhatsApp Forum
- How to calculate on a spreadsheet - Guide
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