Hello again,
Using the if condition is am trying to check If the date is less than today the return Expired or Else it return Valid. Now the problem is if the cell is empty, the return values if Valid.
Column AJ I have to enter date then Column AK have one year expiry date. Column AN will display the value Valid or Expired based on Column Ak date.
Any solution for this.
Last edited by hecgroups; 01-28-2012 at 11:36 AM.
Hi
If i get your point, then, maybe something like this, will do the job
=IF(AK1="";"";???)
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Pl try this formula.
=IF(A1<>"",IF(A1<TODAY(),"Valid","Expired"),"")
Working perfect yaar thanks Mr. Murthy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks