=SUMIF(D:D,""&TODAY())

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Sudz" wrote in message
...

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