+ Reply to Thread
Results 1 to 4 of 4

Number of days since last date.

  1. 07-24-2019, 01:58 PM #1
    jajejllc
    jajejllc is offline
    Registered User
    Join Date
    07-24-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    11

    Number of days since last date.

    I have and Excel sheet where I want to calculate the number of days since a certain date in the past - let's say that date is in column A. In column C, I want the number of days since that date which is =TODAY()-$A2. But what is the formula if I want column C to not show the number of days if column B has a date that has passed already?
    Reply With QuoteRegister To Reply
  2. 07-24-2019, 02:11 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: Number of days since last date.

    maybe this... =IF(TODAY()-B2>0,"",TODAY()-A2)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 07-24-2019, 02:15 PM #3
    jajejllc
    jajejllc is offline
    Registered User
    Join Date
    07-24-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    11

    Re: Number of days since last date.

    That works. Thank you. Whoohoo!
    Reply With QuoteRegister To Reply
  4. 07-24-2019, 02:17 PM #4
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: Number of days since last date.

    Good, glad that worked for you. AND, thank you for the rep!
    Last edited by Sam Capricci; 07-24-2019 at 02:26 PM.
    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. Formula for identifying start date and finish date and associated number of days
    By Fbs1960 in forum Excel General
    Replies: 7
    Last Post: 08-07-2018, 01:48 AM
  2. [SOLVED] Count the number of days in the year to date less the days in the current month
    By Excelski in forum Excel General
    Replies: 16
    Last Post: 08-22-2017, 11:20 AM
  3. testing if one date exceeds today's date by a specific number of days with vba
    By Dana_Carter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2016, 07:49 PM
  4. [SOLVED] How to accurately/precisely count number of months, days from a particular date to a date
    By chaiwala in forum Excel General
    Replies: 5
    Last Post: 07-25-2015, 11:39 AM
  5. calculate number of days between two date within a current month including end date
    By ahgoon in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-06-2015, 09:19 PM
  6. Count the number of days from the date of report upto the date it was closed
    By ECYOJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2014, 04:34 AM
  7. [SOLVED] Number of Days Between Dates but if no Date go to next and return # of Days
    By Bikeman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2012, 12:02 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