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 wrote:
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 St