Calculation of days between 2 dates

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
 
N

Niek Otten

=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
 
Top