I checked that changed the format and I still get the wrong number. Any
other ideas?



galimi wrote:
Check to ensure there is no discrepancy between dates. 1/1/2006 12 AM and
1/1/2006 1 AM formatted just to show the day is a different number.
I am trying to count the number of plan dates (column Z) to Actual Dates
(column AA). H2 is the date cell.
[quoted text clipped - 12 lines]

s2m

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1