expiry date

Hello!! I would like my column of dates to have 3 colors. Let's say that the date expires after 12 months. Based on the current date 6/1/2022 (or current year) Ex. The date entered is 4/13/2022 (this would be green) Ex. The date entered is 6/15/2021 (this would become orange) Ex. The date...

Hello Everyone! I'm hoping that I can get some help with a formula on a spreadsheet I've been asked to work on. We manufacture and sell industrial equipment imported from other country which has either 12 months warranty from shipping date for our customers to sell. So once its sold - warranty...

Hi all, I have been recommended this site by a friend as I am having issues with a spreadsheet I have created and so I would be very grateful if any of you could help me get to where I need to be. So, I have 3 worksheets on my document all of which needs dates input into them. I have a 4th...

Hello, I have a document which has separate sheets for the 10 different containers at work. In these containers are 40 items which all have different expiry dates which are stored in Cells D2-D40. I would like to have a summary sheet which would search all the expiry dates across the 10 sheets...

Hello my life savers! How to set pop-up alert for expiring date in Excel2010. Like I have multiple Items and I only have producing date, but they all expire in 1 year, and I (my boss) would like to get notification one month before it expires. Something like that. Code I made only worked for the...

Hello, I have a code that displays a msgbox when it reaches the date +1. What I'm trying to do is get the code to display the message box if the date in column H9:H100 is over Now()+30 (Today + 30 days) and to continue displaying the expiry message (even after +30 days) until the date has...

Hi, I have a file that needs deleted and I'm looking for advice on how to do just this. What I have is a file with 4 tabs of data, with formulas linking various fields on each sheet. What I would like to do is after a certain date have the file delete upon saving. What I'm not sure is the best...

Hello - I am looking for assistance with my Auto_Open macro. Currently it forces the workbook closed after a designated expiration date. I'm trying to alter it so that users have read-only access to the workbook after it expires, rather than forcing it closed. Any suggestions would be greatly...

Hi there, I'm just looking for help with some data keeping. I have a list of employees that require certain courses to be up to date and would like a function etc that will generate a list of courses that will expire within a month and the employee it corresponds to. Thanks. Mark