Dummy question concerning dates

[sapper]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Start Date
[/TD]
[TD]End Date
[/TD]
[TD]Today's Date
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]12 Sep 18
[/TD]
[TD]12 Nov 18
[/TD]
[TD]23 Jul 18
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]10 Jun 18
[/TD]
[TD]12 Nov 18
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.