View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default If statement with non specific date

If the cell in column D will be either blank or have a date:


E1: =IF(D1<"","package mode","")


In article ,
Eric D wrote:

Can anyone tell me if you can use an IF statement so that it recognizes a
non specific date.

for example: D1 has 6/11/08
I want to enter an IF statement so that if at any time column D has a date
then it will say "package made" in column E right beside the date.

Any suggestions?