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
In K1 enter = TODAY()
L1 your date
In M1 enter = IF( L1K1,"","Y")
If you want "N" in M1 if condition is not met then formula for M1 will
be
=IF(L1K1,"N","Y")
A V Veerkar
--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile:
http://www.excelforum.com/member.php...o&userid=30338
View this thread:
http://www.excelforum.com/showthread...hreadid=509333