dates - how to get 2nd tuesday for 5 years

L

Larry

I need to easily get the dates of various days when meetings take place.
example... first Tuesday of the month
example... second Tuesday of the month
example... third Friday of the month
I tried using the fill function using three cells with the appropriate
dates,
but it just repeated the same dates over and over.
Thanks!!!!!!!!!
 
P

Peo Sjoblom

=A1-DAY(A1)-WEEKDAY(A1-DAY(A1)-2)+8

with the date in A1 the above formula will return the first Tuesday
of the same month as A1, so if you want to get all first Tuesdays for the
next five years put for instance
06/01/04 in A1, in A2 put the above formula in A3 put

=DATE(YEAR(A2),MONTH(A2)+1,1)-DAY(DATE(YEAR(A2),MONTH(A2)+1,1))-WEEKDAY(DATE
(YEAR(A2),MONTH(A2)+1,1)-DAY(DATE(YEAR(A2),MONTH(A2)+1,1))-2)+8

copy down to A62


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top