Need formula to return a specific value if a specified date is between two other dates

If budgetNum is alway number, try:
=SUMPRODUCT((Lists_BudgetStart<=$G3)*(Lists_BudgetEnd>=$G3)*Lists_BudgetNum)
IF it is text, try with INDEX.