Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How can i calculate the first sunday of each month
6,377 views
Skip to first unread message
Kurt
Nov 22, 2001, 7:38:56 AM11/22/01
to
mac
Nov 22, 2001, 7:42:52 AM11/22/01
to
"Kurt" <westv...@hotmail.com> wrote in message
news:ae9001c17352$a6ef7cf0$3def2ecf@TKMSFTNGXA14...
>
go here:
http://www.cpearson.com/excel/topic.htm
Peo Sjoblom
Nov 22, 2001, 8:34:09 AM11/22/01
to
Hi Kurt,
assuming the first date of the month is in A1,
=DATE(YEAR(A1),MONTH(A1),1)+MOD(8-WEEKDAY(DATE(YEAR
(A1),MONTH(A1),1)),7)
first Sunday of the month
=DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH
(A1)+1,1)-1)
last Sunday of the month.
Courtesy of Harlan Grove
Regards,
Peo Sjoblom
J.E. McGimpsey
Nov 22, 2001, 10:00:50 AM11/22/01
to
Just a tad shorter (not necessarily better):
=DATE(YEAR(A1), MONTH(A1),1)+6-WEEKDAY(DATE(YEAR(A1), MONTH(A1), 1),3)
In article <94ef01c1735a$5d923b80$37ef2ecf@TKMSFTNGXA13>, Peo Sjoblom
mtec...@gmail.com
Jul 30, 2016, 11:22:46 PM7/30/16
to
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)
=DATE(YEAR($A:$A), MONTH($A:$A),1)+6-WEEKDAY(DATE(YEAR($A:$A), MONTH($A:$A), 1),3)
mtec...@gmail.com
Jul 30, 2016, 11:30:03 PM7/30/16
to
This worked much better:
=DAY($A:$A)<8
=DAY($A:$A)<8
somasund...@gmail.com
Dec 29, 2019, 4:53:52 AM12/29/19
to
thank you sir its working
0 new messages