$$Excel-Macros$$ Query - Date Formula

2010-07-10 Thread Nikhil Shah
Dear All, Pl help out my query.. *Starting Dt.01/04/1998 ( Format dd/mm/ ) Ending Dt. 31/03/2003 ( Format dd/mm/ )* Loan Dt ( Format should dd/mm/ ) *[ 1 ]* Loan Dt should be between Starting Dt. And Ending Dt...What is formula ? *[ 2 ]..*... If Loan Dt is below

Re: $$Excel-Macros$$ Query - Date Formula

2010-07-10 Thread Vinod N
Hi, Please use Data Validation Select the Date option from Allow dropdown and mention the start and end date in that. If you are not satisfied with the above please send a sample data and the group members will reply.. Thanks Vinod N On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah