Using IF, And ISBLank to determine status

Question

I am trying to create a formula to read a beginning, End, and Activation date to determine if an award is Funded, Funded and Active, or Expired/Closed.  I am able to have formula determine and return a status of Funded and Expired.  I am having an issue combining If statement with ISBLANK and AND formula to return the Funded-Active or Funded-Not Active. This is the formula I have so far & Screen shot of my Sheet columns.

IF(AND([Project Start Date]@row >= DATE(2018, 7, 1), [Project End Date]@row >= TODAY()), "Active",

Thank You

Kelly

Kelly Dawson · Answer

I am trying to determine if there is an activation date then the award is approved/funded and we are allowed to spend against it, if there is no activation date then award is approved/funded, however we cannot start spending against it so it is not active. Hopefully that answers your question

iLoveData · Answer

@Kelly Dawson

Are you looking to use ISBLANK to check the funding status of the "Type column" or are you looking to check against the activation date?