formula for tracking number of elapsed days from a stard date
 

i need to track the number of elapsed days from a start date


--
spm1371
------------------------------------------------------------------------
spm1371's Profile: http://www.excelforum.com/member.php...o&userid=30708
View this thread: http://www.excelforum.com/showthread...hreadid=503737

formula for tracking number of elapsed days from a stard date
 

On Sat, 21 Jan 2006 22:33:30 -0600, spm1371
wrote:


i need to track the number of elapsed days from a start date

=CurrentDate - StartDate

or, possibly,

=NETWORKDAYS(StartDate,CurrentDate, [Holidays])

which requires the Analysis Tool Pak to be installed. See HELP for NETWORKDAYS
if you prefer this function.


--ron