Calculate and print "late" dates

How do I calculate a date?
I have 2 columns. Deadline (column A) and Actual submission date(column B)
I want to do the following.
if A=blank and B=blank, do not print any status
if A<= today(), and B is blank, print late
if B>A, print late.
How do I do this, I tried many ways and end up confusing myself.
Can anyone help?

mosiactu,
This is what I came up with:
Column A ,cell1- "Deadline", Column B, Cell1- "Submission Date"
Column C, cell2 - "=IF(AND(A2="",B2=""),"",IF(AND(A2<=TODAY(),B2=""),"LATE",IF(B2>A2,"LATE","")))" without the first " and last ".

hth
FloMM2

Originally Posted by FloMM2

mosiactu,
This is what I came up with:
Column A ,cell1- "Deadline", Column B, Cell1- "Submission Date"
Column C, cell2 - "=IF(AND(A2="",B2=""),"",IF(AND(A2<=TODAY(),B2=""),"LATE",IF(B2>A2,"LATE","")))" without the first " and last ".

hth
FloMM2

thank u soooo much. i did not realise that i should enter "late" in both cases.
thanks a lot.

btw, i have 2 more questions. does anyone knows??
1. how to i enforce the a particular column, say, column A to accept only dates
2. how do i protect the format of the worksheet and allow users to enter data only