+ Reply to Thread
Results 1 to 3 of 3

Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank

  1. #1
    Registered User
    Join Date
    05-24-2014
    Posts
    34

    Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank

    I am trying to calculate the difference between two dates, today's date and a user entered date.
    Where there is data, this formula seems to work
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    $C$1 is today's current date.
    If U4 is blank I want it to subtract T4 by todays date.
    Seems to work except when there is no date in T4 or U4 it gives a number of 41801.
    I am trying to figure out how to have it lever the cell empty if no data is in T4 or U4.

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank

    Hey, check out the attachmnet
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  3. #3
    Registered User
    Join Date
    05-24-2014
    Posts
    34

    Re: Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank

    I found some help and went with this...
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Seems to be doing the job

+ 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. 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
  2. [SOLVED] help on a simple if text says this input that, if cell is blank leave it blank
    By Rec1ne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 10:43 AM
  3. Replies: 2
    Last Post: 09-20-2013, 01:43 PM
  4. [SOLVED] Simple pull exact text from cell, if blank it pulls up a 0. How to leave it as blank?
    By sharpmel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 02:20 PM
  5. Replies: 4
    Last Post: 07-15-2008, 01:42 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