Previous Topic Next Topic

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
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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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")
Michael
Nov 20, 2011 at 01:31 PM
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
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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 .

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
calculating fuel surcharge
Nancy -
xpcman -

1 response