| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Return the next 1st Tuesday of a Month
On Sat, 01 Dec 2007 17:43:49 -0500, Ron Rosenfeld
wrote: In any event, modified: =IF(A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-2)A1,A1-DAY( A1)+8-WEEKDAY(A1-DAY(A1)-2),DATE(YEAR(A1),MONTH( A1+1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1+1),6))) Oh, and I interpreted the OP's request for the "Next" Tuesday to mean that if TODAY is a Tuesday, the "Next" Tuesday would necessarily occur in the future. --ron This is wrong, too. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| dates and 1st Tuesday of month | Excel Worksheet Functions | |||
| Return mm/dd/yy based on 1st Day of Month | Excel Worksheet Functions | |||
| Calculating first/last Monday, Tuesday, etc. in a given month in E | Excel Worksheet Functions | |||
| Return 1st of the Month | Excel Worksheet Functions | |||
Hybrid Mode
