Calculate # of Days from one date to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks.
 
=DATEDIF(C8,D8,"d")

c8, d8 are dates, note that D8 should be greater than c
 
May be a simple question, but how to I calculate the number of days from Jan
1, 2004 to a another specific date?

Thanks.
Click to expand...

=A1-B1

or

=A1 - DATE(2004,1,1)

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


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
days calculation between dates 10
I need help with a Function 0
Number of days 2
Calculate eligibility/enrollment date 8
How do I get a new calculated date from different date ranges? 3
Excel PRICE function: How does it compute Issue Date of the Security 5
days calculations 6

Back
Top