A Art3277 Mar 20, 2010 #1 I would like to calculate a date, 10 weeks after a set date and return the date of that tenth week monday? Is this possible.
I would like to calculate a date, 10 weeks after a set date and return the date of that tenth week monday? Is this possible.
L Lars-Åke Aspelin Mar 20, 2010 #2 I would like to calculate a date, 10 weeks after a set date and return the date of that tenth week monday? Is this possible. Click to expand... If your set date is in cell A1, try the following formula: =A1+70-WEEKDAY(A1,3) Hope this helps / Lars-Åke
I would like to calculate a date, 10 weeks after a set date and return the date of that tenth week monday? Is this possible. Click to expand... If your set date is in cell A1, try the following formula: =A1+70-WEEKDAY(A1,3) Hope this helps / Lars-Åke
T T. Valko Mar 20, 2010 #3 See if this does what you want... A1 = some date B1 formula: =A1+70-WEEKDAY(A1+70,3) Format as Date (if needed)
See if this does what you want... A1 = some date B1 formula: =A1+70-WEEKDAY(A1+70,3) Format as Date (if needed)
