advanced access training - How to calculate to 2 different dates

Hi Nawaz

I assume you mean how to calculate the difference between two dates. To do this use the following formula:

=DateDiff(<Interval>, [First Date], [Second date])

The interval can be:

"d" for day, "m" for month,"y" for year, etc

Regards

Carlos