expiration

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

Hi All, I am trying to understand the best combination of formulas to calculate the sell through of products with different expiration dates. All products with the closest expiration date (column c) to todays date (cell E1) by SKU (column a) should be depleted first inline with the weekly...

So I have specifation register listing 300 products, the date the specifcation was issued and the date the specification expires. Specifications expire after 3 years. I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the...

Hi all - I have a tenant info sheet that contains a lease expiration date. I am attempting to create a formula that either calculates the month and year of the lease end date or results in "MTM" (month-to-month) when the lease expiration is in the past. I have a helper column that...

Can anyone advise if I can give an excel file an expiration date so user can no longer access the data after a predetermined expiration date?

Is there any way to compare one end date to two start dates, calculating whichever start date is later? For example: <colgroup><col><col></colgroup><tbody> Expiration Date 4/7/2018 Assignment Date 6/19/2018 Submission Date 11/8/2018 142 Expiration Date 4/7/2018 Assignment Date...

OK, I have expiration dates in cells B3:B100 when TODAY hits that expiration day that cell turns red, in cells C3:C100 there is a Expiration day -30, when TODAY hits -30 days from expiration day that cell turns pink. I want to receive an "alert notice" via email when C3:C100 turns pink. i.e. i...

Hi all, When entering a formula, we often need to choose between entering TRUE or FALSE. (I would always enter a zero but it seems FALSE is more reliable.) Entering TRUE would be for an APPROXIMATE result, but I tested this and need to ask – What rules are used to determine approximate?? The...

Hi, Can someone help with this one? Based on an initial date, need to calculate 3 years later end of year. Example: Expiration date is the last day of the third succeeding calendar year Initial date: 19/09/2018 End date: 31/12/2021 Thanks! Helena

Table Name = Training Status Column #1 = Category Column #2 = Expiration Date I would like to count all the cells in the "Expiration Date" greater than a certain date (30 September 2019) and only if the "Category" = First Aid. Here is the DAX formula I have but is giving me an error...

Hello guru's! I'm trying to get a popup window to show when a date is entered that is less than 8 months from today's date. I also need it to send out the alert when the spreadsheet is opened. Basically, Column A is the part number, Column B is the lot number and Column C is the expiration...

Greetings - I am attempting to create a working inventory that will automatically detect expiration dates in three separate columns (which I'll call Column A, Column B, and Column C) and place the outcome ("Expired") in Column D. What I want the formula to do is to look at Column C first*...

Ive tried a few different scripts on how to auto sort by date but i can't seem to find one that works or maybe there is an underlying issue, i want to sort my sheet by expiration date so soonest date is at top but also so i can continue to add rows down the page as needed for new clients. The...

Hello, I was playing around with cpearson's timebomb at http://www.cpearson.com/excel/workbooktimebomb.aspx . I set Const C_NUM_DAYS_UNTIL_EXPIRATION = 0 and the timebomb worked. I then set it back to 30 but the file still closes. Is there an easy way to reset the expiration date? Thanks...

I don't know why I'm getting a Type Mismatch error. I'm trying to do a simple subtraction macro with a variable row spreadsheet and getting a Type Mismatch error on this line of code: I'm subtracting two dates, column I which contains expiration date must cell "AA1" which contains today's date...

Hi, I have a spreadsheet with an Expiration Date column, with dates ranging from some expiring this year to 2021. I need to have dates become yellow when they are less than 3 months from their expiration date and red when they are less than 2 months from expiring. I know I need to do some...

Hi Excel guru's. I have have to track orders that must be completed within a certain date range, e.g. within 90 days of create date. A simple formula of can address what the expiration date would be, however often these expiration dates land on a weekend. Simply using a =WORKDAY() is...

Good afternoon excel gurus. I'm currently working on a project with several rows that have expiration dates in Column E. I have 2 tabs, 1 labeled "TRACKER" and the other labeled "ARCHIVE". The expiration dates in the tracker tab are set so that once the expiration date is passed, the row turns...

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...

I had an account on here, but not sure what happened to it so here's to a new one! My issue is as follows: I need to create a formula, process, or otherwise that allows me to take two columns of dates (say G1:G100 and H1:H100) and take whichever is smaller of the two (easy enough right...