1. D

    Ideas on how to track inventory expiration dates

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

    Depletion for expiration date product - multiple batches

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

    Days between dates and color coding

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

    Calculating lease end month/year

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

    expiration date for excel file

    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?
  6. tkroper

    DATEDIF with two start dates

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

    email alert when date is getting close to expiring

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

    "TRUE" for an Approximate result in a formula

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

    formula to calculate expiration date: last day of third succeeding calendar year

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

    Trying to Count Number of Cells filtered on Another Column

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

    VBA popup box warning of expiration date

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

    Creating a nested IF statement for mulitple expiration dates

    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*...
  13. C

    Auto Sort By Date

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

    How to Reset Expiration Date on TimeBomb (cpearson method)

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

    VBA - Type Mismatch error in date subtraction macro

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

    Format cells to highlight within time frame for future 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...
  17. R

    Exclude Weekends

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

    End Dates & Self Destruct Date

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

    Auto_Open macro: read-only after expiry?

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

    Complicated Scheduling

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back