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 aren't expired.

One way is to use a helper column.

If Form 1 uses columns A, B, C, D, put this in E1 and copy down:
=IF(TODAY()=D1,A1,"")
So E:E contains the state for each license that's not expired.

Then in Form 2 use the COUNTIF function with range E:E. Excel's built-in
Help describes the function.