I currently have 3 columns in my spreadsheet, that pulls information
from a data dump I get from a database. The 3 columns are based on
years (2006, 2005, 2004). I have them setup as

2004 2005 2006
=Now()-730 =Now()-365 =Now()

so that they dynamically change when the year changes. Below them the
rows contain the information I want displayed by year. However, the
date column in the data dump I get gives dates formatted like this:
2005-09
I have a dsum that looks at a different column, and sums based on
country, but in order to make sure that the values appear based on the
year in the date column, how would I set that up? I obviously need to
be able to look at only the first 4 characters in the date fields
values, but how? Plus, it needs to look at the year in the column
header, and only give the values related to that year from the date
column in the data dump.

Any and all help is greatly appreciated!


--
Toon
------------------------------------------------------------------------
Toon's Profile: http://www.excelforum.com/member.php...o&userid=31337
View this thread: http://www.excelforum.com/showthread...hreadid=515421