Solved Days360 will not ignore blank cells

December 3, 2014 at 09:12:32
Specs: Windows 7
I am keeping track of the difference in days between when a project was assigned and when it was turned in.
While updating my sheet in real time, assignments that have not yet been turned in display a large number in error.
I would like the column of "difference in days" to return nothing, if the "date turned in" column is blank.

Here is my example
=DAYS360(F7, AB7, TRUE)

AB7 is the "date turned in", AB7 is blank.
F7is the "date assigned"

Please Help!

message edited by ILoveCoffee

See More: Days360 will not ignore blank cells

Report •

December 3, 2014 at 10:01:42
✔ Best Answer
Try this:

=IF(AB7="","",DAYS360(F7, AB7, TRUE))

Simply check to make sure the "Date Turned In" cell has something in it
before doing the calculations.

Also, may I ask, is there a reason you are using the DAYS360() function?
This function is used mainly in the finance world to simplify calculations.


Report •
Related Solutions

Ask Question