Calculate # of Days from one date to another

jscano · Nov 10, 2004

May be a simple question, but how to I calculate the number of days from Jan
1, 2004 to a another specific date?

Thanks.

anilsolipuram · Nov 10, 2004

=DATEDIF(C8,D8,"d")

c8, d8 are dates, note that D8 should be greater than c

Ron Rosenfeld · Nov 11, 2004

May be a simple question, but how to I calculate the number of days from Jan
1, 2004 to a another specific date?

Thanks.

=A1-B1

or

=A1 - DATE(2004,1,1)

Be sure to format the result as General (or Number).

--ron