Results 1 to 3 of 3

calculate time remaining with 3 date variables

Threaded View

  1. 01-03-2020, 04:41 PM #1
    megs2113
    megs2113 is offline
    Registered User
    Join Date
    11-10-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    2

    calculate time remaining with 3 date variables

    Hi,

    Currently I have this formula in column J which calculates months remaining based on two date values and TODAY (). I want to expand this to include the date in column E if both date values in column G and column I are lapsed and/or blank.

    =IFERROR(IF(G5>=TODAY(),G5-TODAY(),I5-TODAY())/30.4,"-")

    Can someone please help? I cannot figure it out. Example workbook attached.

    Thank you!
    Megan
    Attached Files Attached Files
    Last edited by megs2113; 01-03-2020 at 07:10 PM. Reason: solved
    Reply With QuoteRegister To Reply
« 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. How to calculate amount of debt remaining over time
    By Izzii0x in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-18-2018, 10:01 AM
  2. [SOLVED] How to calculate time remaining in an interval?
    By prudential in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2018, 11:04 AM
  3. [SOLVED] How to calculate Time Left (remaining time) using percentage
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2017, 10:55 AM
  4. [SOLVED] Calculate time remaining
    By WendyvdV in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-27-2015, 08:44 AM
  5. [SOLVED] Calculate time remaining based on end date & time and current date
    By Kaz09 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 08-19-2014, 07:11 AM
  6. Calculate Remaining Days left from Todays Date
    By lewisale in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-22-2013, 07:21 PM
  7. Formula to Calculate Number of Appointments remaining within a period of time!?!?!
    By WaylettChris in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 11-14-2012, 09:39 AM

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