Excel formula question

my formula is 1/31/2010-today() and today is 1/2/2010. The value it returns is 28, why is that?

I appreciate your help because I am excel dumb
dmitchell81
Asked Jan 02, 2010
Because the way the computer calculates it is through an array, and the first cell of the array is at an address of 0. Basically, it's going 0, 1, 2, 3...27, 28. So you're getting the full 29, but you get a number of 28 because it's including 0. If you want to get an exact number, you should make your formula add 1 to compensate.
Oni_Kami
Answered Jan 02, 2010

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories