Finding If current date is Between two dates

What formula can be used to find if todays date is between two dates.

A projects duration is:

12/1/17 to 12/31/17

Today is 9/27/17......display "Not Started"

or


A projects duration is:

9/1/17 to 12/1/17

Today is 9/27/17.....display "In progress"

Assuming that:

• A2 = Start Date

• B2 = End Date

The formula would be: =IF(AND(TODAY()>=$A2,TODAY()<$B2),"In progress","Not Started")

See Attachment

Thanks for posting this thread as SOLVED, but it would had been nice to know if the formula I provided was actually what you needed. Or that you found a better solution.
And a simple THANK YOU would had went a long way

I apologize, I thought I had sent a thank you over. I appreciate the help!!