The first Tuesday of the following month must be 28 or 35 days from the
previous month so you can use:

=IF(MONTH(C26+28)=MONTH(C26),C26+35,C26+28)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


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