Excel tips : how to filtering to a date range in the past

could you tell me please how to calculate days between two different dates i am tried to using many formulas but i m unsuccsessful ..please tell me procedure to calculate days 

             i m attatched file please put the formula and show me how to calculate days

_____________________________________________________________________Thank you ___

suppose you have date in a1 (18-apr-2011) and date in a2 (20-apr-2011)

formulat to calculate days between two date is very simple just type in a3

=a2-a1

and format that cell to numbers from date format

Its so simple.. just try

YOU CAN USE IF FUNCTION ALSO. THIS IS VERY EASY.

DEDUCT THE EARLIEST DATE FROM LATEST DATE. AND FORMAT IT IN NUMBER FORMAT.

NOW APPLY THE FOLLOWING FORMULAE

IF((A1)<98,IF((A1)>91,"REQUIRED DATE","NO USE"))

A1- NO OF DAYS

REQUIRED DATE- THOSE ARE THE DATES WHICH ARE REQUIRED BY YOU. i.e.91-98

NO USE- DAYS THAT DOES NOT FALL WITHIN OUR RANGE

could you tell me how to protect a folder with pass word in Windows?

Hi Praveen

I am attaching a file that contains a simple marco, which filtering transactions based on their dates....

Just like in tally, how you can change the period, here also period can be changed and the transactions during the respective period is displayed.

Regards

Rangarajan Krishnan

Sorry, here is the file