WORKDAY function
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: WORKDAY function

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am using the workday function (w/ brackets for holidays). I also want to use the month end date even if it falls on the weekend or holiday. For instance, the last business day for June is the 28th (Friday) and June 30 is a Sunday. For my spreadsheet I want to show June 30.

    Can this be done?

    Thanks



  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this link, you should find everything you ever wanted to know about working with dates here...............

    http://www.cpearson.com/excel.htm

    Denny

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,772
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-04-15 08:08, mcarter973 wrote:
    I am using the workday function (w/ brackets for holidays). I also want to use the month end date even if it falls on the weekend or holiday. For instance, the last business day for June is the 28th (Friday) and June 30 is a Sunday. For my spreadsheet I want to show June 30.

    Can this be done?

    Thanks
    Would this work?

    =IF(EOMONTH(A1,0)=WORKDAY(A1,E1,Holidays)-1,EOMONTH(A1,0),WORKDAY(A1,E1,Holidays))

    where E1 houses the desired number of workdays and Holidays is the name of the range that houses the holiday days.

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
  •  

 

 
DMCA.com