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

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.