Hpw to display result if date is prior to today

Im trying to display a text result if a date is before today's date, and I can't get the formula right (although I'm sure its quite simple!) my best guess is
=IF(TODAY()>=L2,"Overdue","Current"

I need the calculation rather than conditional formatting so that i can create a pivot chart.

Thanks in advance for any suggestions

That should work fine. What exactly is in L2?

L column has expected end dates, L2 specifically has 09/08/2012 so it should be returning Overdue, but the cell just sits there with the formula displayed in it.

If your formula is displayed then the cell is either in text format or you've toggled Show Formulas.

If it's the former, go to the format bar at the top, choose General. Click the cell, hit F2, and enter.

If it's the latter, hit Ctrl+` (Ctrl + the key next to 1)

Thanks, that fixed it! the cells are now showing a result, but all cells are showing the false result, when the date in column L is before today so should be showing the true result

Sounds like a logic issue; just swap the outputs. =IF(L2<=today(),"Current","Overdue")

I've swapped the logic outputs, but still only getting one result, except now its the true result for everything.