IF Function for dates with Conditional Format

[jenna_max]

Hi,

I have a worksheet which has employees and their licences with the expiry dates on it. I have a conditional format to show when the expiry date is within 30, 15 and 7 days. I have this referenced to a mastersheet, which has the formula =IF(INDEX('Licences & Tickets'!$I$7:$I$168,MATCH(A10,'Licences & Tickets'!$A$7:$A$168,0))="","","a") which shows a tick that the employee has it. I want to change the individual sheets to have another column in it, which will show the expiry date if it is still in date, but I want it to go blank if the expiry date has passed. I will then change the cell reference on the mastersheet to correspond with this so if their licence has expired it will show that they don't have it any more.

I have tried using an IF function but can't get it to work. I want it to be something like =IF(cell=Date,"yes","") I'm not sure how this would work as I don't know how to make it so it can pick up any date, not a specific date.

Any help and advice will be appreciated

[samba_ravi]

attach an excel file

[jenna_max]

Found a formula that works -
=IF(cell<NOW(),"","y")