Closed Thread
Results 1 to 6 of 6

Workday formula

  1. #1
    Registered User
    Join Date
    04-22-2010
    Location
    Oxford, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Unhappy Workday formula

    Here's my formula at the moment: =(J2<TODAY()+5)

    What I want : =(J2<TODAY()+5WORKDAY) - But this does not work???

    I have a date in a cell when an application for payments must be made. I want a warning to appear 4-5 days before hand which I already have but I don't want weekends included in those 4-5 days.

    If anyone can give me a formula that does this it would be very much appreciated!!!

    Thank you

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Workday formula

    Please stick to your original thread - you've been offered advice regards use of NETWORKDAYS - please utilise it.

    http://www.excelforum.com/excel-prog...e-in-cell.html

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Workday formula

    Possibly

    =IF(J2<TODAY()+5,IF(WEEKDAY(INT(J2))<6,"Workday","Weekend"),"")

    Not to sure what you want the result to be.

  4. #4
    Registered User
    Join Date
    04-22-2010
    Location
    Oxford, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Workday formula

    Quote Originally Posted by Marcol View Post
    Possibly

    =IF(J2<TODAY()+5,IF(WEEKDAY(INT(J2))<6,"Workday","Weekend"),"")

    Not to sure what you want the result to be.
    That didn't work but thanks anyway.

    What I want the result to be: Say my deadline for a payment application is on wednesday (28/04/2010) I need a warning to pop up 4 days before hand but not including the weekend, so it would turn red today.

  5. #5
    Registered User
    Join Date
    04-22-2010
    Location
    Oxford, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Workday formula

    Quote Originally Posted by DonkeyOte View Post
    Please stick to your original thread - you've been offered advice regards use of NETWORKDAYS - please utilise it.

    http://www.excelforum.com/excel-prog...e-in-cell.html
    That advice didn't help at all

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Workday formula

    I suspect because you have not read the help files.

    Although this is, to some extent, a silver spoon service we do expect people to read links referenced or follow advice re: help files.
    Moreover we do not expect users to repeatedly post the same question given this is a waste of time for all concerned.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1