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/454525-how-can-i-calculate-first-sunday-each-month.html)

[email protected]

How can i calculate the first sunday of each month
 
thank you sir its working

Tim Paine

how can i calculate the first sunday of each month in excel
 
The CHOOSE and WEEKDAY functions allow us to craft a formula that returns the first Sunday in a month.
If you type a different month-end date in cell A1, such as 1/31/2015 then cell B3 will return 2/1/2015, as shown in Figure 4. The first Sunday of February 2015 happens to fall on the first of the month.

I hope this helps!
Tim Paine


All times are GMT +1. The time now is 07:53 PM.

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