Week Ended Friday

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 20 Sep 2007 06:40 GMT

Hi

Could anyone help me that I am writing a formula the allow me to bring the
date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1
(where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or
A1=7 Sep 07 (Monday) cell B1 will also show me the result 7 Sep 07 (Friday).
I use vlookup on it doesn't work especailly the date on Friday. Please help.
Thank you.

Reply to this Message

Rick Rothstein (MVP - VB) - 20 Sep 2007 07:00 GMT

Give this formula a try...

=A1+6-WEEKDAY(A1)

Rick

> Could anyone help me that I am writing a formula the allow me to bring the
> date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1
[quoted text clipped - 4 lines]
> help.
> Thank you.

Reply to this Message

Tony - 20 Sep 2007 07:10 GMT

Thank you so much Rick. It works perfectly

> Give this formula a try...
>
[quoted text clipped - 10 lines]
> > help.
> > Thank you.

Reply to this Message

Ron Rosenfeld - 20 Sep 2007 11:13 GMT

On Thu, 20 Sep 2007 02:00:20 -0400, "Rick Rothstein \(MVP - VB\)"
<rickNOSPAMnews@NOSPAMcomcast.net> wrote:

>Give this formula a try...
>
[quoted text clipped - 10 lines]
>> help.
>> Thank you.

I'm not sure if it's what the OP wants, but your formula:

Saturday, Sep 01, 2007 --> Friday, Aug 31, 2007

Whereas

=A1+7-WEEKDAY(A1-6)

Saturday, Sep 01, 2007 --> Friday, Sep 07, 2007

--ron

Reply to this Message

Rick Rothstein (MVP - VB) - 20 Sep 2007 15:00 GMT

>>Give this formula a try...
>>
[quoted text clipped - 23 lines]
>
> Saturday, Sep 01, 2007 --> Friday, Sep 07, 2007

That's a fair point. My impression when I first read the OP's post was that
his dates where weekdays only (no weekends), but that is only a gut-feeling.

Rick

Reply to this Message