dates and 1st Tuesday of month
One way,
first formula, assume you put it in C27
=C26-DAY(C26)+8-WEEKDAY(C26-DAY(C26)+5)
will give you the first Tuesday's date of the month and year in C26 assuming
you have a real date in C26, so if you have 07/01/07 it will return 07/03/07
then in C28 put
=DATE(YEAR(C27),MONTH(C27)+1,1)-DAY(DATE(YEAR(C27),MONTH(C27)+1,1))+8-WEEKDAY(DATE(YEAR(C27),MONTH(C27)+1,1)-DAY(DATE(YEAR(C27),MONTH(C27)+1,1))+5)
select C28 and copy down as long as needed
--
Regards,
Peo Sjoblom
"Jessica" wrote in message
...
C26 is my start date and I need every first Tuesday/month. Thanks!!
"Jessica" wrote:
How can I get the cells to populate with the dates of the 1st Tuesday of
the
month?
I tried =C26+7+7*(MONTH(C26+7)=MONTH(C26)) but that gives me every
Tuesday.
Thanks.
|