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