+ Reply to Thread
Results 1 to 3 of 3

Leave cells blank when there is not a date in the other cell that it is using to calculate

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Leave cells blank when there is not a date in the other cell that it is using to calculate

    I need to update a current formula for it to leave blank the formula cell if it encounters anything that is NOT a date (for instance, HOLD, TBD, blank cells, etc.) in the cell it is using to calculate. Both columns (Q and R) are formatted as dates.

    The formula is in cell R2 (Target Date) and it takes the date from Q2 (Date Received) and adds to it 5 days, considering weekends and holidays.

    Here is the formula in cell R2 thus far:
    =WORKDAY(Q2,5,HOLIDAYS!A:A)

    So if my Date Received (Q2) is 1/2/2018, my Target Date (R2) should be 1/9/18 (5 days from 1/2/18 considering the weekend).

    Note: Since I have a list of holidays that are unique to our company, I created a list of these in a separate "HOLIDAYS" worksheet - that is why you see the reference to that worksheet.

    Thank you

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Leave cells blank when there is not a date in the other cell that it is using to calcu

    Try

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Leave cells blank when there is not a date in the other cell that it is using to calcu

    This works - Thank You!

+ 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. Replies: 3
    Last Post: 02-17-2016, 08:26 AM
  2. [SOLVED] IF Cell is blank, calculate, if cell isn't blank, leave blank
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2015, 03:54 PM
  3. Replies: 3
    Last Post: 02-09-2015, 09:00 AM
  4. Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2014, 11:31 PM
  5. IF Statement to leave cell blank if multiple cells are all blank
    By sweeteri in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2014, 12:02 PM
  6. Replies: 5
    Last Post: 05-29-2013, 12:27 AM
  7. Replies: 4
    Last Post: 07-15-2008, 01:42 PM

Tags for this Thread

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