Thread: How can i calculate the first sunday of each month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] mtech801@gmail.com is offline
external usenet poster
  
Posts: 2
Default How can i calculate the first sunday of each month
Would it be this if I want it to do it for all rows and the A column has all the dates to be validated?

=DATE(YEAR($A:$A), MONTH($A:$A),1)+6-WEEKDAY(DATE(YEAR($A:$A), MONTH($A:$A), 1),3)
Reply With QuoteReply With Quote