+ Reply to Thread
Results 1 to 2 of 2

use workday function based on either or date with conditional formatting

  1. #1
    Registered User
    Join Date
    11-21-2019
    Location
    australia
    MS-Off Ver
    2016
    Posts
    17

    use workday function based on either or date with conditional formatting

    Hi
    I want to calculate 20 business days from either date a or date b using a formula. Then I want to conditionally format the cell so that if today is past the 20 business days from either date a or date b the cell turns red. I have created the list of public hols and used the workday function to calculate the 20 business days from a single but am having trouble calculating the 20 business days if Date A is blank and Date B has data and vice versa.
    I have stuck a `in front of the formula so I can see what I am testing in the cell below. I keep getting error message of either too many arguments or not enough parenthesis. I've spent hours trawling through previous posts but couldn't find one that was an exact fit for my scenario.

    Any pointers greatly appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: use workday function based on either or date with conditional formatting

    In C2:
    =IF(A2="","",WORKDAY(IF(B2="",A2,B2),20,PubHols))

    CF formula:
    =TODAY()>WORKDAY(C2,1,PubHols)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting use of WORKDAY
    By TRAZ6666 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2018, 08:24 AM
  2. [SOLVED] Employee End Date with WORKDAY.INTL() function using Hire Date
    By XLOOKUP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2017, 12:18 PM
  3. date and workday function
    By arcticreaver in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-14-2015, 06:05 PM
  4. [SOLVED] Workday and conditional formatting?
    By bhogbo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 08:35 AM
  5. [SOLVED] WORKDAY function and conditional formatting
    By okyjelly in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2013, 09:19 PM
  6. Workday formula on a Conditional Formatting
    By Kinna in forum Excel General
    Replies: 5
    Last Post: 05-29-2009, 03:02 PM
  7. WORKDAY function and conditional formatting
    By alexander in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2005, 04:43 PM

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