Thread: first saturday in a month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default first saturday in a month
This seems to work: =a1-DAY(a1)+8-WEEKDAY(a1)

"Barry" wrote:

I need a formula to find the first saturday in the month. i.e. cell a1
contains the date 2006 02 01, i need to know the first saturday in feb.
Reply With QuoteReply With Quote