Calculation date

[Jochen Munzinger]

Hello everyone,

I want to find out how many days there between two given dates . A1 is for
example 01.01.2006 and A2 is 01.02.2006 and in A3 I want the amount of days
there are between A1 and A2.

How can I do that?

I appreciate any help and wish you all a great day!

Greetz

Jochen

 

[Ardus Petus]

=A2-A1
Format as number

HTH