May I ask for a formula please?
Use the IF function,
=IF(L1<=K1,"Y","N")
if L1 is less than or equal to K1, put a Y in the current cell, otherwise
put an N in the current cell.
Jim
"bob" wrote:
I am new to this.
Cell K1 will display the current date, if cell L1 is equal or less than
current date then it will display letter "Y" in cell M1.
Many thanks
Bob
|