I want to enter regular entries in a spread sheet (of meter readings to
track utility cost) and in one column I want to determine the cost per
day. I therefore enter the date in column A (set as "Date" field),
followed by such items as meter reading, unit rate, etc. In one column
I want to subtract for example last reading date from prior reading
date; this value to divide the total period cost to determine the daily
cost.

It seems that there is no way I can get a result using DATEDIF, even
copying any samples expressed by various bulletin boards.

In desperation I have used the manual method of converting the date
value to it's numerical component and doing a simple subtraction to get
the desired result.

Surely, DATEDIF should allow me to leave the (date) field in date
format so that one can readily see the real date without having to do a
further conversion.

Am I expecting too much, or missing something?

Thanks for reading this and providing help.

TAS-LGS


--
TAS-LGS
------------------------------------------------------------------------
TAS-LGS's Profile: http://www.excelforum.com/member.php...o&userid=28358
View this thread: http://www.excelforum.com/showthread...hreadid=479408