View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jessica Jessica is offline
external usenet poster
 
Posts: 113
Default dates and 1st Tuesday of month

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.