Remember Me?

#1
July 31st 16, 04:22 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2016 Posts: 2
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)

#2
July 31st 16, 04:30 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2016 Posts: 2
How can i calculate the first sunday of each month

This worked much better:

=DAY(\$A:\$A)<8

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Charlotte E.[_2_] Excel Programming 5 November 28th 08 02:28 PM Bob Excel Worksheet Functions 5 March 31st 08 04:32 PM Arne Hegefors Excel Programming 2 October 26th 07 10:56 AM jeromevw Excel Discussion (Misc queries) 2 May 13th 07 05:07 PM Minitman Excel Worksheet Functions 6 December 2nd 05 09:34 PM

All times are GMT +1. The time now is 11:06 AM.