expired

Hello, I have a complex sheet that has hundreds of employee's on who have completed courses. As each month i have to give a list of name to my boss about whose course has been expired (Courses last 2 years). I have the userform all set up, however i can't seem to get the code to search and...

I am attempting to create a spreadsheet that will help to track the period of expiration of a number of items. And, because it's been a long, long, long time since I've used Excel, I am lost! I've tried following the tutorials on-line, but just can't seem to make it work for me. What I need...

Hi, Ive been for this report that i cant figure how to work. Can someone help me with a formula that will display expired remarks. For example i have =IF(k5>NOW,k5<<now,if(m5>NOW,IF(m5><now,if(o5>NOW,m5<NOW,IF(o5><now,if(s5>NOW,o5<NOW,IF(s5>NOW,s5<NOW))<now)) k5, m5, o5, s5 are the columns...

I am not sure if this is possible. I have a list of of possible movies that a cinema can show throughout the year. However, each movie is typically only available for 10 weeks after it is initially released. Therefore, I would like to make a condensed list of movies which not expired past those...

Hi everyone I am fairly new to VBA and excel but here is what I am trying to do. I want my excel file to check the dates in column "b" a week in advance and send an email if the date is expired. This program will be opened once a week so I want it to check up to 7 days in advance and send the...

I have a list of employee working in our company with expiry dates of their national ID. I already tried a nested if statement and its giving two output Expired and Valid. My one issue is that when it reaches to an empty cell its says "Expired", even though I'm expecting it to be empty also...