Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 !! -- Ashutosh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between two dates | Excel Discussion (Misc queries) |