Display comment after class date has passed

[Ltat42a]

Hello All, I'm using this formula to countdown the number days until a class starts. It works good. How can I modify this so that when the class is over, the countdown will display "Class is over"?
=IF(A6="","No class selected",(A6-TODAY()&" day"&IF(A6-TODAY()>1,"s","")))

Thanks

[boopathiraja]

Hi, You mean this ?

=IF(A6="","No class selected",IF(A6>=TODAY(),(A6-TODAY()&" day"&IF(A6-TODAY()>1,"s","")),"Class is Over"))

[Ltat42a]

Ah man, that works good, Thanks!

[Ace_XL]

If A^ equals today you might want to display 'class is over' rather than 0 day.

Tweak boopathiraja's formula to

=IF(A6="","No class selected",IF(A6>TODAY(),A6-TODAY()&" day(s)","Class is Over"))