Date Functions

J

Jules

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
J

Jules

Thank you so much!
--
Jules


Ron Rosenfeld said:
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
Click to expand...
 
Top