Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Functions
I am trying to determine the date in which the 1 and 3 tuesday of the month
falls...is this possible? Thanks for your help. -- Jules |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Functions
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Functions
On Wed, 5 Jul 2006 05:25:02 -0700, Jules
wrote: I am trying to determine the date in which the 1 and 3 tuesday of the month falls...is this possible? Thanks for your help. In general, the first n-day of a month can be determined by: =A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+1-DOW) where A1 = any date during that month and where DOW = Day of Week (Sun=1, Mon=2, Tues=3) The third n-day is the above +14. So for the first Tuesday: =A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-2) Third Tuesday =A1-DAY(A1)+22-WEEKDAY(A1-DAY(A1)-2) If A1 is always the first day of the month, then: First Tuesday: =A1+7-WEEKDAY(A1-3) Third Tuesday: =A1+21-WEEKDAY(A1-3) --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Functions
Thank you so much!
-- Jules "Ron Rosenfeld" wrote: On Wed, 5 Jul 2006 05:25:02 -0700, Jules wrote: I am trying to determine the date in which the 1 and 3 tuesday of the month falls...is this possible? Thanks for your help. In general, the first n-day of a month can be determined by: =A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+1-DOW) where A1 = any date during that month and where DOW = Day of Week (Sun=1, Mon=2, Tues=3) The third n-day is the above +14. So for the first Tuesday: =A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-2) Third Tuesday =A1-DAY(A1)+22-WEEKDAY(A1-DAY(A1)-2) If A1 is always the first day of the month, then: First Tuesday: =A1+7-WEEKDAY(A1-3) Third Tuesday: =A1+21-WEEKDAY(A1-3) --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Functions
On Wed, 5 Jul 2006 08:06:01 -0700, Jules
wrote: Thank you so much! -- Jules You're welcome. Glad to help. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Date Functions | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Date functions | New Users to Excel | |||
search for latest date | Excel Worksheet Functions |