I created a basic formula to calculate the number of days between two dates
in a worksheet, i.e. =K2-A2. The formula worked fine in the 1st cell,
accurately calculating the number of days, so I dragged the formula to the
remaining cells in Column K through 100. The problem is that in the cells
where there is no value entered yet, Excel is calculating and returning
negative numbers, -39728, -39752, etc. I'd like the cells without values to
remain blank until information has been entered. Thanks in advance for the
help.
--
Bev