Results 1 to 5 of 5

days360 with today() shows different value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    days360 with today() shows different value

    Hey Guys,

    I need a small help.

    Range "K" has the formulae
    TODAY()
    In range "L" I want to substract range "K" with range "D" using Days360

    The formulae I am using in cell "L2" is
    DAYS360(D2,K2)
    The formulae works well but when range "d" is empty then it shows 42669

    I want it to show blank if range "d" is empty


    I have attached my workbook.

    Please help me
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating a Dynamic Chart that shows from Today for 100 days forward, changing daily
    By Robbie8 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-26-2016, 08:13 PM
  2. [SOLVED] Function Arguments window shows result, cell shows a 0
    By fluffsmckenzie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2013, 05:48 PM
  3. [SOLVED] DAYS360, need to calculate from today's date for null values
    By skgates in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2012, 04:24 PM
  4. DAYS360
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 03:05 PM
  5. DAYS360
    By Jan Buckley in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] DAYS360
    By Jan Buckley in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] DAYS360
    By Jan Buckley in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1