Thread: Incorporating IF Function into DAYS360 Function

Working on a spreadsheet, I have used the following Formula to locate the days between NOW and a past date: =DAYS360(End Date,NOW()).

Example (1)

A1 A2
1/19/2012 7<--- Result after using Formula =DAYS360(A1,NOW())
Past Date Result



Some of my cells do not have a "past date" and the cell is blank. So when the above referenced formula is entered it returns a value of: 40346

Example (2)

B1 B2
BLANK 40346<--- Result after using Formula =DAYS360(B2,NOW())
No past
Date Avail

I am trying to locate a formula that will display a false, NONE, or 0 instead of 40346.
So in turn, I would like my informatio to be clean like below.


A1 A2
1/19/2012 7
B1 B2
<Blank> NONE or 0

HELP?! Please....

You could try using =IF([cell number] <1,NO)
this would display no within the cell if there is no value matching.

using (absents) suggedtion, it now says #NAME? as the result. Here is my NEW formula =DAYS360(NOW(),[Cell number])=IF([Cellnumber] <1,no)