ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can i calculate the first sunday of each month (https://www.excelbanter.com/excel-worksheet-functions/451686-re-how-can-i-calculate-first-sunday-each-month.html)

[email protected]

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)

[email protected]

How can i calculate the first sunday of each month
 
This worked much better:

=DAY($A:$A)<8


All times are GMT +1. The time now is 09:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com