Date manipulation

[theconquerer]

Hello,

Is there an easy way to find the number of days between two dates entered in an excel macro?

For example, if A1=2/6/2003 and A2=2/6/2004 Id want it to return in A3 365

Thanks a lot,

Charles

 

[Oaktree]

=A2-A1, just format A3 as a number