EOWEEK --- similar to EOMONTH

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Nov 16, 2006.

  1. Guest

    Guest Guest

    Hi,

    I know there isn't and EOWEEK function, but there should be :)

    I get lots of requests each day and want to run them through reports
    showing incoming per week, etc...

    So I would like to find an equation that would look at the request date
    and then tell me it was requested in the week ending "X".

    For example:

    Req Date = 11/13/06 week end date = 11/17/06
    Req Date = 11/1/06 week end date = 11/3/06
    Req Date = 11/27/06 week end date = 12/1/06

    etc...

    Thanks!

    Jon
     
    Guest, Nov 16, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Try something like this:

    With
    A1: (a date)

    This formula returns the Friday day of the week containing A1
    B1: =A1-WEEKDAY(A1,2)+5
    Weeks run Monday thru Sunday

    Is that something you can work with?
    ***********
    Regards,
    Ron

    XL2002, WinXP


    "Jonathan Horvath" wrote:

    > Hi,
    >
    > I know there isn't and EOWEEK function, but there should be :)
    >
    > I get lots of requests each day and want to run them through reports
    > showing incoming per week, etc...
    >
    > So I would like to find an equation that would look at the request date
    > and then tell me it was requested in the week ending "X".
    >
    > For example:
    >
    > Req Date = 11/13/06 week end date = 11/17/06
    > Req Date = 11/1/06 week end date = 11/3/06
    > Req Date = 11/27/06 week end date = 12/1/06
    >
    > etc...
    >
    > Thanks!
    >
    > Jon
    >
     
    Guest, Nov 16, 2006
    #2
    1. Advertisements

  3. =A1+6-WEEKDAY(A1)
    --
    David Biddulph

    "Jonathan Horvath" <> wrote in
    message news:...
    > Hi,
    >
    > I know there isn't and EOWEEK function, but there should be :)
    >
    > I get lots of requests each day and want to run them through reports
    > showing incoming per week, etc...
    >
    > So I would like to find an equation that would look at the request date
    > and then tell me it was requested in the week ending "X".
    >
    > For example:
    >
    > Req Date = 11/13/06 week end date = 11/17/06
    > Req Date = 11/1/06 week end date = 11/3/06
    > Req Date = 11/27/06 week end date = 12/1/06
    >
    > etc...
    >
    > Thanks!
    >
    > Jon
    >
     
    David Biddulph, Nov 16, 2006
    #3
  4. Guest

    Guest Guest

    Thanks guys, both solutions work...

    Jonathan



    "Jonathan Horvath" wrote:

    > Hi,
    >
    > I know there isn't and EOWEEK function, but there should be :)
    >
    > I get lots of requests each day and want to run them through reports
    > showing incoming per week, etc...
    >
    > So I would like to find an equation that would look at the request date
    > and then tell me it was requested in the week ending "X".
    >
    > For example:
    >
    > Req Date = 11/13/06 week end date = 11/17/06
    > Req Date = 11/1/06 week end date = 11/3/06
    > Req Date = 11/27/06 week end date = 12/1/06
    >
    > etc...
    >
    > Thanks!
    >
    > Jon
    >
     
    Guest, Nov 16, 2006
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. daver676

    EOMONTH function

    daver676, Aug 21, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    334
    Ron Rosenfeld
    Aug 21, 2003
  2. Guest

    EOMONTH

    Guest, Oct 26, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    495
    Peo Sjoblom
    Oct 26, 2003
  3. Brendon

    =DAY(EOMONTH(E4,0)) doesn't work in Excel 03

    Brendon, Nov 17, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    943
    Harlan Grove
    Nov 17, 2003
  4. Chris

    Is there an End of Week function similar to the EOMONTH?

    Chris, Jan 23, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    316
    Peo Sjoblom
    Jan 23, 2004
  5. Sid

    Missing EOMONTH Function in Excel 2003

    Sid, Apr 7, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    10,955
Loading...

Share This Page