+ Reply to Thread
Results 1 to 3 of 3

Date formulas

  1. 10-23-2020, 03:54 PM #1
    Jeffreyh
    Jeffreyh is offline
    Registered User
    Join Date
    08-28-2020
    Location
    Olympia, A
    MS-Off Ver
    2016
    Posts
    3

    Date formulas

    I am sure there is a easy fix , I have a simple formula "=TODAY()-B3", but what is B3 is not know yet or empty, right now I get 44,127 days. I just want it to remain empty until I have a date for B3.


    Capture.JPG

    Thanks
    Last edited by Jeffreyh; 10-23-2020 at 04:09 PM.
    Reply With QuoteRegister To Reply
  2. 10-23-2020, 04:05 PM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,497

    Re: Date formulas

    Try this:

    =IF(B3="","",TODAY()-B3)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-23-2020, 04:08 PM #3
    Jeffreyh
    Jeffreyh is offline
    Registered User
    Join Date
    08-28-2020
    Location
    Olympia, A
    MS-Off Ver
    2016
    Posts
    3

    Re: Date formulas

    Worked perfect. Thank you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. continous formulas if this date give me this but if this other date five me that and so on
    By sabrinaxiomara in forum Excel General
    Replies: 2
    Last Post: 12-30-2016, 03:54 PM
  2. Formulas Calculating Age based on Date of Birth & Date of Death
    By MELLOW YELLOW in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-07-2014, 03:27 PM
  3. How to record changes in cells with Formulas (date after date entires)
    By hasnraz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2013, 12:53 PM
  4. Date formulas - PLEASE HELP!
    By KatieB83 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-30-2013, 11:21 AM
  5. Excel 2007 : Future Date Formulas and Adjacent Cell Formulas
    By thetaylor13 in forum Excel General
    Replies: 4
    Last Post: 02-09-2011, 04:33 PM
  6. Formulas - count the amount of working weeks from a date until present date
    By Andrew_Franklin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2008, 09:23 AM
  7. [SOLVED] DATE Formulas
    By Digital2k in forum Excel General
    Replies: 2
    Last Post: 06-30-2006, 05:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1