Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to Automatically determine the date of the most recent

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello again,

    I have a question...is there a built-in function in Excel or a macro that can automatically determine the date of the most recent saturday?

    For instance, say I run a particular report this coming Monday - April 1st(not always on monday, could be any day of the week). There is a header in the spreadsheet that says "Data as of MM/DD/YYYY" where the date is the most recent saturday relative to that day (april 1st)..where the date would display as "03/30/2002". Is there a way to dynaically determine this date.. regardless of what day the report is run, relative to the previous saturday?

    Thanks in advance,

    Rob

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,427
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try one of the following; edit references and text as necessary.

    ="Data as of : "&TEXT(TODAY()-WEEKDAY(TODAY(),3)-2,"ddd dd mmm yyyy")

    ="Data as of : "&TEXT(A50-WEEKDAY(A50,3)-2,"ddd dd mmm yyyy")

    [ This Message was edited by: Dave Patton on 2002-03-29 11:08 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-29 11:06, Dave Patton wrote:
    Try one of the following; edit references and text as necessary.

    ="Data as of : "&TEXT(TODAY()-WEEKDAY(TODAY(),3)-2,"ddd dd mmm yyyy")

    ="Data as of : "&TEXT(A50-WEEKDAY(A50,3)-2,"ddd dd mmm yyyy")

    [ This Message was edited by: Dave Patton on 2002-03-29 11:08 ]
    BOTH of those worked to perfection.. THANKS!

    Rob

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •