find out if date is between range - Excel Templates | Excel Add-ins and Excel Help with formulas a

if I have 2 dates 21/05/2006 and 23/05/2006, how can I find out if 22/05/2006 exists between them ... A number of assumptions to make: A1 contains the start date, B1 contains the end date, C1 contains the date to check. Also, "between" can either mean ...

www.ozgrid.com