You haven't provided an example so it is difficult to answer your question, however; here is a site ( http://www.meadinkent.co.uk/datesandtimes.htm) that is a pretty decent reference for Excel functions. Utilizing Excel as a database has it's drawbacks as it is really a spreadsheet tool. A rudimentary database can be created though, and hopefully, the date/time functions you will find in the above link will help you.
__________________
"The gift of liberty is like that of a horse, handsome, strong, and high-spirited. In some it arouses a wish to ride; in many others, on the contrary, it increases the desire to walk."
-- Massimo d'Azeglio
|