G
Guest
Hi,
I need to express the difference between two dates in a decimal form correct
to two decimal points. However, if the two dates are the start and end of two
months, say, 1st March 2007 and 30th April 2007, I want the answer to appear
as 2.00 (being two complete months between the dates), and not as 1.98, which
is the answer Excel gives me. I cannot use the Round option because it rounds
off intermediate decimal figures to the nearest whole number. In other words,
while it rounds off 1.98 to 2.00 (desired), it also rounds off 0.67 to 1.00
(not desired). What formula will help me to achieve what I want? I don't want
to add a '+1' either. Is there anyway to get this? Thanks !!
I need to express the difference between two dates in a decimal form correct
to two decimal points. However, if the two dates are the start and end of two
months, say, 1st March 2007 and 30th April 2007, I want the answer to appear
as 2.00 (being two complete months between the dates), and not as 1.98, which
is the answer Excel gives me. I cannot use the Round option because it rounds
off intermediate decimal figures to the nearest whole number. In other words,
while it rounds off 1.98 to 2.00 (desired), it also rounds off 0.67 to 1.00
(not desired). What formula will help me to achieve what I want? I don't want
to add a '+1' either. Is there anyway to get this? Thanks !!