Help with calculating data from different fileds
 

Thanks in advance for your help.
I have a spreadshet of different products, each product has a date it was
entered. I want to be able to calculate how long each prodcut is outstanding.
I have another spreadhseet that lists each product and breaksdown the weeks
eg. 0-3 weeks, 4-6 weeks. So I need to figure out how to first of all only
search for a spacific product and then to calculate how many weeks it has
been outstanding for. So if I have 10 investments (example) outstanding, how
many are between week 0-3 weeks and how many 4-6 etc. I find this very hard
to explain without sharing the spreadsheet. I am using Excel 2003 so I know I
need to calculate it in days as the weeks function does not work on this
version. Hopefully someone will understand what I am talking about :-)

Help with calculating data from different fileds
 

You could simply subtract the dates from today's date =TODAY() and get the
number of days difference and then divide by 7 to get the number of weeks

Tyro

"Stewart1979" wrote in message
...
Thanks in advance for your help.
I have a spreadshet of different products, each product has a date it was
entered. I want to be able to calculate how long each prodcut is
outstanding.
I have another spreadhseet that lists each product and breaksdown the
weeks
eg. 0-3 weeks, 4-6 weeks. So I need to figure out how to first of all only
search for a spacific product and then to calculate how many weeks it has
been outstanding for. So if I have 10 investments (example) outstanding,
how
many are between week 0-3 weeks and how many 4-6 etc. I find this very
hard
to explain without sharing the spreadsheet. I am using Excel 2003 so I
know I
need to calculate it in days as the weeks function does not work on this
version. Hopefully someone will understand what I am talking about :-)