Stumped!!

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:56 PM GMT

Question

I have a formula that I am trying to have calculate using the DAYS360 formuala. I got the formula to work the way I want it to however when the start date of the formula is blank then the cell where my answer should be comes up with a long number. How do I get that cell to remain blank if there is no data in that row? Here is the formula, =DAYS360(C4,S4) Cell C4 is a date that I will enter and cell S4 is a TODAY() formula. This is what comes up in the cell with the DAYS360 formula when it is blank, 39650. Any assistance you can provide would be very much appreciated!!!

SFC Cameron Beck

Answer

Cameron:

If a cell is blank it is essentially the same as the cell being Jan 1, 1900. Thus, the DAYS360 function is returning the number of days between today and the beginning of the previous century (quite a few).

To solve this problem I suggest using this function:

=IF(C4>0,DAYS360(C4,S4),"")

Please let me know if you have any additional questions!

Advertisement

©2017 eLuminary LLC. All rights reserved.