Dummy question concerning dates

[sapper]

	A	B	C
1	Start Date	End Date	Today's Date
2	12 Sep 18	12 Nov 18	23 Jul 18
3	10 Jun 18	12 Nov 18

<tbody>
</tbody>

How do you write a formula if you have dates in threedifferent columns. I am trying to determine if the ‘Start Date’ is prior to ‘Today’sDate’ and before the ‘End Date’. The reverse is also a concern, if the ‘StartDate’ is after ‘Today’s Date’ and before the ‘End Date’.

I hope this understandable. Thanks in advance.

 

[JoeMo]

Assuming you wouldn't enter an End Date that's before the Start Date, in D2 and copy down:

=IF($C$2>B2,"Today is beyond End Date",IF(AND($C$2>=A2,$C$2<=B2),"today is between start and end dates",IF($C$2  <  A2,"today is before start date")))
  <a2,"today is="" before="" start="" date","today="" on="" the="" date")))

</a2,"today>

 

[sapper]

Thanks Joe,

Worked like a charm.