Calculate # of Days from one date to another

[jscano]

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]

=DATEDIF(C8,D8,"d")

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

 

[Ron Rosenfeld]

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