Hi.
I have a formula in a cell =IF(O2>0,"COMPLETE",(TODAY()-K2+1)*H2)
As you can see in attachment 1.pdf If I put a money value in H2 it returns a value in L2 as 431,670.00
If I put the date as per 2.pdf the formula works perfect.



I am relatively new to formulas but I do know that it seems to be calculating from 1900 date.
Can anyone suggest a change to the formula that can show the correct value without having a date entered?

Attached Files

	1.pdf (10.1 KB, 10 views)
	2.pdf (10.2 KB, 8 views)

Excel uses a 5 digit number to represent dates so that it can do calculations...

today's date, for instance is represented as 43166. (to see this enter today's date in a cell, then format it as General).

Now 43166-0 = 43166 and 43166+1 = 43167 which when multiplied by 10 gives 431670..... so there should be a date of some kind in column K.

Hi MBVC, thanks for getting back to me.
That was the conclusion, problem is, when we do a rental but do not have a start date but we still need to do the calculation financially. Wondered if another expression in the formula could allow this dual result to happen. IE, no date financial figure applied in Column K, a cost of 10.00 in total daily cost will appear in L.

or

Hi.
Worked a treat thanks very much, appreciated.