need to know more about how your data is laid out and how you want to
see the result to give you any specific function advice.
General ideas -
=datedif(start date, end date,"D") this function will allow you to
calc dif between 2 dates in days.
=weeknum(date) will give you the week number
= you can use sumif and countif to sum data and get averages based on
different criteria. Or you can use sum product formula to with
different criteria.
--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile:
http://www.excelforum.com/member.php...o&userid=24503
View this thread:
http://www.excelforum.com/showthread...hreadid=391112