calculating the number of days between 2 dates
Posted by Chris Jones on September 04, 2001 12:52 PM
I want to calculate the number of the number of days the occur between the date in cell g6 and e6. I've tried the 360DAYS worksheet function, it didn't work, and I tried DAY(G6)-DAY(E6, which is ok for calculating between 2 dates in the same month, but goes out of wack when a different month is involved in calculation.
I've been trying the following:
But it gives me a #NUM! error.
Does anyone know how to do this?