2010 to 2003 conversion counting a range of cells in a period of time prior to today

Hi
I am looking for some help if possible. I am by no means overly proficient with Excel, I know enough to do the basics and have manages to "wing it" till now.

After much forum and soul searching I had come up with the following formula, which I will discuss what it is supposed to do. (It seems to work fine in Office 2010 but doesnt work at all in 2003 which unbeknownst to me is what the file must be formatted to)

=SUMPRODUCT(--(Deploy!T3:Deploy!T60<=TODAY()),--(Deploy!T3:Deploy!T60>(EDATE(TODAY(),-12))))

Deploy being the Sheet name, cells T3-T60 are the cells which are in a date format (essentially a date a qualification was gained). The formula is to work out the number of cells that fall in a date rage 1 year prior to today's date. It seems to work fine in 2010 but when i tried to open the file in 2003 the area where i had totalled the various stats broken.

If someone can figure out a simplified version of the formula it would be much appreciated indeed. As I use this formula and a few modified versions of it (mostly month count changes) through out the worksheet.

I have over 50 people on the worksheet each with around 50 qualifications all of which last different periods of time. if it would help i can post an image of the worksheet up.

Many thanks in advance

Regards
-J0hn0

I guess that in 2003 it returns a #NAME? error, the formula should work fine, excel 2003 just needs a kickstart.

http://office.microsoft.com/en-us/ex...001127724.aspx

yes it is the #name result returned
i will try the addins fix, but im pretty sure they wont be on the system as its quite archaic.

Many thanks for you help so for i will keep you updated i will head back into work now.

thank you very much for your help, it actually worked with the tools>addins fix!

MUCH APPRECIATION for you taking the time to help!

-Johno

funny-celebrity-pictures-thank-you-for-the-help-young-lady.jpg