Use DATEDIF() to find difference between two dates

With start date in A1 and end date in B1
=DATEDIF(A1,B1,"d")

To find difference from today
A1 = start date
=TODAY()-A1
(and format to general)

If this post helps click Yes
---------------
Jacob Skaria


"watermt" wrote:

I need to count the total number of days (counting all days of the week)
elapsed between process 1 through 12. Using the m/d/yyyy hh:mm cell
formatting, not all 12 processes will have a date/time entered (blank cell).

When I use the following function; =NETWORKDAYS(F1,F12) and I have a blank
cell (i.e., F9) I get the #Name? error. Is there a way to have the function
ignore blank cells?

And finally, which function do I use to count all 7 days of the week?

Mike