"IF()" function using "TODAY()" to produce a value in days

Hi,

I'm a little stumped on why the formula I've created only half works.

=IF(N5=" ",TODAY()-K5,N5-K5)

The intent here is the following.

I have three columns, first being the "start date" of a task, the second being the "end date", and lastly a "how many days have passed since the start date".

So the last column is supposed to do the following: If N5 (end date) is empty, show how many days have passed by taking today's date and subtracting K5 (start date).

Here's the problem. The "False" value is showing perfectly, but the "Today()-K5" is showing a -41207 value.

Anyone able to provide a little advice on this formula?

Greatly appreciated in advance.

Rob.

You are not testing for an empty cell (""), you are testing for N5 containing a space (" "). Remove the space between the two quotes in your formula.

Hope this helps.

Pete

Oh wow. Here I was looking for some complex issue and it just something I should have already known! Appreciate the help all the same! Thanks guys.