How to subtract 2 dates to get number of days.....please

  • Thread starter Thread starter Nick
  • Start date Start date
Hi Nick,

Just subtract the oldest date from the newer one and format the result as General or Number, not Date.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've tried fornatting, to no avail.......I'm on Excel '97.
|
| Cheers
|
| Nick
|
|
 
Nick,

Simple subtraction will work. Excel stores dates internally as numbers.
When one of the cells involved in an arithmetic operation has a certain
format Excel often uses the same format for the output. You have two
options:

=B2-A2
and format the cell as general. Or,

=VALUE(B2-A2)

HTH
Kostis Vezerides
 
you could use
=datedif(Date1,Date2,"d")

datedif() is a useful function in EXCEL, but you won't find it in help
 
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

How to subtract a number from a Mergefield? 0
Workday Formula to include date 0
Formula Subtracting Business Days 3
Subtracting data when copied from a IE screen 2
Hello happy new year to all, Text box input for year of purchase 0
How do I subtract/add a known number of days/months from a date? 2
Excel Subtract text after the third space and before the fourth (from between spaces) 3
VLOOKUP and Return Last 2 Values 5

Back
Top