expire

Hi Everyone I have the excel file to control storage as attached link. The Sheet1 is an storage, and sheet2 contains goods which I want to take out.... I want to compare the quantity at Sheet2 with quantity at Sheet1 of item "Apple" with code is "AP" base on the current date&time and Expire...

Hey All hope all is well, I'm hoping to get a little help with a notification when a date is near expire date. I have several columns of when employees training certificates expire, I would like excel to tell me in A:7 that the dates expire soon. some of the columns have blanks, I have this...

Hi everyone first of all my apologies if this is something really simple I should be able to figure out on my own. I currently have a spread sheet in which users input the date an individuals license is due to expire. For example in the worksheet titled "MHE" the employees name would be in cell...

I am using the below code for making my workbook expire Text if Date >#03/08/2017 #Then ThisWorkbook.Close.False End if End sub There is a downside, ie if we change the system time the workbook will function to normal How to make the workbook expire after a period of time?

I have a list of names in cells A1:A10 I also have a list of dates in B1:B10 which are course dates (Formated 12-May-16) What i'm struggling to do is create a MsgBox to pop up if today's date is in column B. I would like the box to say "Did <name> pass this course?". If yes, it would colour...

I'm after a conditional format forumla that checks each value of a cell in a column and shows the word EXPIRED (and highlighted red) if the current date is past the date entered, and shows the word RENEW (and highlighted blue) if the current date is within 30 days of the date in the cell. Also...