I have a logic to be implemented.
I have a start date and end date in both ddmmyyyy or mmddyyyy formats available along wit a variable today column.
Start Date=
17/1/2016
End Date=
17/10/2016
Today=
19/01/2016
I want a formula that if my today is falling between start date and end date, I want to flag it as Active, Else Inactive.
Please suggest forumula