This is pretty hard to explain but ill do my best. Im trying to figure
out a formula for this problem

This is using multiple forms in the Spreadsheet,
Form 1:

License State License Number Date Issued Date Expired

Form 2:

This is where i need to formula that i cant figure out. Say i have 50
States, 1,000 License Numbers per state, but of course they have
different issue and expiration dates. What i want this formula to do is
to give me a total number of Licenses that arent expired.


--
Sudz
------------------------------------------------------------------------
Sudz's Profile: http://www.excelforum.com/member.php...o&userid=36083
View this thread: http://www.excelforum.com/showthread...hreadid=558674