View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default how do i set date as 1st thursday of every month

If you want to list those dates you can put
=DATE(2007,ROW(),1)+5-WEEKDAY(DATE(2007,ROW(),1)) or
=DATE(2007,ROW(),6-WEEKDAY(DATE(2007,ROW(),1)))
into row 1, & copy down into rows 2 to 6.
--
David Biddulph

"srpingbokiwi" wrote in message
...
i am drawing up a schedule for Jan to Jun 2007. I need to schedule a
meeting
every 1st thursday of the month.

thanks
springbokiwi