Home |
Search |
Today's Posts |
#23
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Return the next 1st Tuesday of a Month
Elegant.
-------------------------- Best Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Harlan Grove" wrote in message ... Sean wrote... ... Just to clarify, I'm using the date as a notice of when a Report is due to be returned. The bases is that its due on "the 1st Tuesday of each month", but specifically its due by 12pm on the 1st Tuesday, so if the user opened up the file at 2:00pm on the 1st Tuesday, he/she should see the following months 1st Tuesday date. If the user opened the file up at 10:00am on the 1st Tuesday, he/she should see the current days date pop up Then you could use a simpler formula. For the date/time in A3, =INT(A3-WEEKDAY(A3-1.5,2)+7*MATCH(TRUE,DAY(A3-WEEKDAY(A3-1.5,2) +7*{1;2;3;4;5}+0.5)<8,0)+0.5)+0.5 |
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 |