Results 1 to 2 of 2

Is there a EOWEEK?

This is a discussion on Is there a EOWEEK? within the Excel Questions forums, part of the Question Forums category; Greetings, I know of the EOMONTH function, but is there an "end of week" function? I can't see one when ...

  1. #1
    Board Regular
    Join Date
    Feb 2008
    Location
    Glendale, Arizona USA
    Posts
    312

    Default Is there a EOWEEK?

    Greetings, I know of the EOMONTH function, but is there an "end of week" function? I can't see one when I search for it in Excel. My application is that when working with future dates, I would like to automatically adjust the date for the end of the week as opposed to a Wednesday or Thursday.

    For example, if I enter a date for "today()+7", I would like to return the value to reflect the date for next Saturday. Hope that makes sense. Thanks for the help, RB

  2. #2
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Location
    Edinburgh
    Posts
    7,150

    Default Re: Is there a EOWEEK?

    Here's one way to get the date of the following Saturday, for a date in A1

    Code:
    =a1+7-weekday(a1,1)
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

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
  •  


DMCA.com