Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Last day of week
4 views
Skip to first unread message
Job
Mar 9, 2005, 10:51:11 AM3/9/05
to
Anyone know how to calculate the last day of the calendar week? Assuming
that you have a date in A1, I need to calculate the last day of the week
(Sunday is first day), for the week that contains the date in A1.
that you have a date in A1, I need to calculate the last day of the week
(Sunday is first day), for the week that contains the date in A1.
Cheers,
Job
Jason Morin
Mar 9, 2005, 11:15:35 AM3/9/05
to
=A1+7-WEEKDAY(A1)
HTH
Jason
Atlanta, GA
>.
>
Peo Sjoblom
Mar 9, 2005, 11:25:01 AM3/9/05
to
So you want the coming Saturday except if the date is Saturday?
with the date in A1
=A1+7-WEEKDAY(A1)
--
Regards,
Peo Sjoblom
"Job" <J...@nomail.com> wrote in message
news:e8CLQ$LJFHA...@TK2MSFTNGP10.phx.gbl...
Bob Phillips
Mar 9, 2005, 11:29:47 AM3/9/05
to
see response in programming
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Job" <J...@nomail.com> wrote in message
news:e8CLQ$LJFHA...@TK2MSFTNGP10.phx.gbl...
Ron Rosenfeld
Mar 9, 2005, 11:25:46 AM3/9/05
to
I guess if Sunday is the first day, that Saturday must be the last day of the
week?
=A1+7-WEEKDAY(A1)
--ron
Job
Mar 9, 2005, 11:22:10 AM3/9/05
to
Perfect! Thanks Jason.
"Jason Morin" <jason...@OPPOSITEOFCOLDmail.com> wrote in message
news:4c1b01c524c3$39dd6340$a501...@phx.gbl...
0 new messages