Return Days since Date Entered in Column.

[Mcasteel]

I have a worksheet with a column containing dates ('A').

I want to keep a running total of how many days (for example: '180'
from the date in column A.

I noticed if I simply subtract the date from todays date, the valu
returned is formated as a date. I want just the days rolling (180)
instead somethign like this '01/30/1900' which I tend to end up with.
Any suggestions?

Someone earlier suggested NETWORKDAYS(a1-b1). but it didnt seem t
work.

Mik

 

[Ron de Bruin]

Hi Mcasteel

Select the formula cell and goto Format>Cells and format
the cell as General

 

[Don Guillett]

change the format??

 

[DMoney]

Here is a formula that I frequently use for date variances.

=DAYS360(H4,G4)