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

unread,
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.

Cheers,

Job


Jason Morin

unread,
Mar 9, 2005, 11:15:35 AM3/9/05
to
=A1+7-WEEKDAY(A1)

HTH
Jason
Atlanta, GA

>.
>

Peo Sjoblom

unread,
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

unread,
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

unread,
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

unread,
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