Calculating differences between dates

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

Guest

Can someone tell me what formula to use to calculate the difference between
two dates.
For example one date being 11/1/1987 and the other date being current.

Thank you,

Alison
 
microsoft.com...1/ cell A1 contains the date you wanted
2/ cell b1 contains =TODAY() - must be depending on your language (for me
it's AUJOURD'HUI () )
3/ cell c1 =b1-a1 returns a number of days. You could use for A1 and b1 a
standard format instead of Date format . this will returns a serial number
instead of the 'readable date'
 
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 elapsed time excluding specific timeframe 10
Calculating date/time intervals?? 1
Excel PRICE function: How does it compute Issue Date of the Security 5
Lookup between two dates 3
Difference between date and time 7
Difference between dates 9
CALCULATE DAYS PER MONTH BETWEEN 2 DATES 2
IF Statement with Dates & Calculations 5

Back
Top