+ Reply to Thread
Results 1 to 5 of 5

days360 with today() shows different value

  1. 07-09-2018, 11:34 AM #1
    anilpatni1234
    anilpatni1234 is offline
    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 
    Please Login or Register  to view this content.
    In range "L" I want to substract range "K" with range "D" using Days360

    The formulae I am using in cell "L2" is 
    Please Login or Register  to view this content.
    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
    Reply With QuoteRegister To Reply
  2. 07-09-2018, 11:36 AM #2
    AliGW
    AliGW is offline
    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,780

    Re: days360 with today() shows different value

    So this, then:

    =IF(D2="","",DAYS360(D2,K2))
    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. 07-09-2018, 11:56 AM #3
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: days360 with today() shows different value

    Hey ,

    Thank you for your response.

    I had worked out on this same formulae myself. But it does not work.
    I am attaching the sample file. Please check.

    It still shows 42669
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-09-2018, 11:59 AM #4
    AliGW
    AliGW is offline
    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,780

    Re: days360 with today() shows different value

    If you use Evaluate Formula on the Formulas ribbon you'll see why. Try this instead:

    =IF(D2=0,"",DAYS360(D2,K2))
    Reply With QuoteRegister To Reply
  5. 07-09-2018, 12:04 PM #5
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: days360 with today() shows different value

    Hey Thank you .

    Thanks so much.''

    It worked
    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. [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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1