Thank you very much.

"Ruthki" wrote:


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