Calculation of days between 2 dates

  • Thread starter Thread starter Jochen Munzinger
  • Start date Start date
J

Jochen Munzinger

Hello everyone,

I have a problem: I want to calculate then amount of days between two given
dates.

A1: 01.02.2006
A2: 01.03.2006
A3: amount of days

How can i do that?

Thanks for any help!

Greetz
Jochen
 
=A2-A1, Format as General, not as Date, which Excel does automatically

--
Kind regards,

Niek Otten

| Hello everyone,
|
| I have a problem: I want to calculate then amount of days between two given
| dates.
|
| A1: 01.02.2006
| A2: 01.03.2006
| A3: amount of days
|
| How can i do that?
|
| Thanks for any help!
|
| Greetz
| Jochen
 
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

Calculation date 1
excel formula 1
days between dates 3
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
date / time difference 7
Calculating tax on rebates 2
Possible to do without a Macro? 1
Excel DateDif - why does 2007 seem different? 3

Back
Top