+ Reply to Thread
Results 1 to 7 of 7

Count number of days from a start date to today BUT end at a certain date

Hybrid View

  1. 06-07-2018, 12:56 AM #1
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,670

    Re: Count number of days from a start date to today BUT end at a certain date

    In J4 then drag across
    =IF(OR(J$3<$D4,J$3>$E4),"",NETWORKDAYS($D4,MAX(TODAY(),J$3))*$H4)
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    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. Calculate number of days between invoice date and today's date
    By JHerrick in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-30-2020, 03:53 PM
  2. How to compute the number of days between a given date(fomat) against today date
    By jinwei in forum Excel General
    Replies: 4
    Last Post: 03-20-2017, 01:25 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. Calculating the number of days between 2 dates using today's date until 2nd date is added.
    By RYLEE.HART in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-28-2016, 06:09 PM
  5. Count Consecutive Days from Today's Date
    By sinspawn56 in forum Excel General
    Replies: 6
    Last Post: 04-24-2015, 06:39 PM
  6. [SOLVED] Find date using start date and number of network days
    By v!ctor in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 05:27 PM
  7. [SOLVED] count the number of cells with a date <= today's date
    By Cachod1 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-27-2006, 05:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1