+ Reply to Thread
Results 1 to 4 of 4

formula help please. date-date but if cell blank then today-date

  1. #1
    Registered User
    Join Date
    04-06-2022
    Location
    California
    MS-Off Ver
    Pro Plus 2010
    Posts
    2

    formula help please. date-date but if cell blank then today-date

    hello i'm sure this is a simple one but I'm a rookie with formulas and this one has got me.... :-(

    ok so this is a hold report and I want to track the amount of days something has been on the report so...

    =SUM(TODAY()-(B147)) I got that no problem. That give me a active count that goes up daily.
    but I also want when the date of the hold release is entered to lock that number of days on hold...so if a date is entered then....
    =SUM(J147)-(B147)

    all in one formula so basically if J147 has a date use that date do not use Today.


    I hope I made that clear....
    Last edited by BKRiley; 04-06-2022 at 01:51 PM. Reason: solved

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: formula help please. date-date but if cell blank then today-date

    First of all, you don't need the SUM( ... )

    Try it like this:

    =IF(J147<>"",J147,TODAY()) - B147

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-06-2022
    Location
    California
    MS-Off Ver
    Pro Plus 2010
    Posts
    2

    Re: formula help please. date-date but if cell blank then today-date

    yep that is it, thanks for taking the time Pete.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: formula help please. date-date but if cell blank then today-date

    You're welcome, and thanks for the rep.

    Pete

+ 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. [SOLVED] Add multiple Date Dif together to get total length of service, if date blank, use TODAY
    By Kanderton in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2022, 02:59 PM
  2. [SOLVED] Formula for converting a date to quarter and leaving blank cell for no date values
    By jayc2111 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2019, 12:57 AM
  3. Using TODAY Date Function in formula and leaving cell blank until needed.
    By slugger23 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2016, 05:04 PM
  4. Replies: 5
    Last Post: 12-01-2015, 02:36 PM
  5. Date of Birth/Age/Today's Date and Blank Cells
    By jdawg1536 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2015, 10:49 PM
  6. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  7. Replies: 1
    Last Post: 10-02-2012, 02: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