View Single Post
  #3   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

Sorry, correction:
=DATE(2007,ROW(),1)+MOD(5-WEEKDAY(DATE(2007,ROW(),1)),7)
--
David Biddulph

"David Biddulph" wrote in message
...
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