Nathannc85

New Member
Joined
Feb 23, 2014
Messages
2
I need some help here. I've looked everywhere but can't seem to find it.
I have a due date in B2 and =TODAY() in A1. I need a formula that says if B2 is <= today then it will say "late" but if B2>today then it will say ""

please help. These formulas confuse me big time.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,118,607
Messages
5,573,188
Members
412,511
Latest member
hbarnett
Top