difference between the dates ex: 4/11/2008- 7/11/2008= 3 days

  • Thread starter difference between the dates ex: 4/11/2
  • Start date
D

difference between the dates ex: 4/11/2

how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3
days
 
R

Roger Govier

Hi

If the earlier date is in cell A1, and the later date in cell B1
=B1-A1
Format the cell with the formula as General.

If you want to enter dates in the formula, you need to enclose the dates
within double quotes
="07/11/2008"-"04/11/2008"
and give the later date first.

Rather than typing dates it is better to use the Date function
=DATE(2008,11,7)-DATE(2008,11,4)

--
Regards
Roger Govier

"difference between the dates ex: 4/11/2" <difference between the dates ex:
4/11/[email protected]> wrote in message
news:[email protected]...
 

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

plese show me as a demo how to caliculate the difference between 2
Time Zone Conversion Table 1
Linking Child Timelines to Multiple Parents 0
IF ARRAY with multiple conditions. 1
Looking for a formula 3
Calculating greatest number in a range 2
XIRR problem 5
Formula to total labor charges 3

Top