Calculating a future date

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have a worksheet that needs to calculate the third weds. from today. So for example today is 11/19/11 in cell A1. I need cell B1 to tell me what the third weds. is from today. an if today was 11/23/11 then what is the third weds. from then. Thanks.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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")
It works well but I needed it to calculate what ever the THIRD weds. from today is. So if it's actually today then it is the tird weds from today. Thanks
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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 .