1. E

    Product expiry date help

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

    Error In Expiry Date Formula

    I am getting the following error in the Expiry date formula in workbook Private Sub Workbook_Open() Dim Edate As Date Edate = Format("31/12/2012", "DD/MM/YYYY") ' Replace this with the date you want If Date > Edate + 2 Then MsgBox "This workbook is Expired and will now close !!!"...
  3. B

    how to make a reminder pop up notification

    hello friends, please help, my boss want me to make a reminder due to expiry date of our license. the alert must be based on (the expiry date - 10), and the pop up will display the No.License. the expiry date is in column I No.License is in column F <colgroup><col width="27"><col...
  4. S

    Minimum of the multiple dates for a Product

    Hi, I have a list of products and associated dates. A product will have multiple materials and each material have a expiry date. Something like table below. <colgroup><col span="2"><col></colgroup><tbody> Product Material Material Expiry AA a 16-Aug-23 AA b 17-May-23 BB b 18-Aug-25...
  5. S

    List the Expired Dates

    If column A are names, and Column B are expiry dates for their cards, is it possible that I open a new spreadsheet, and draw only the expired name & date on the sheet? I have multiple of cards that required to draw expiry date to another sheet, will the formula be similar? Thanks for your help.
  6. E

    Issues for pasting range of data

    Hi All I would like to create a macro where i can paste Columns of Option, Strike and Expiry in respective sheets(sheet name is on left). I have written a macro. please advice the necessary changes <tbody> SheetNAme Option Strike Expiry NIkit c 11200 27-Jun-19 sandeep P 11300 27-Jun-19...
  7. E

    Loop Functionality

    Hi All I would like to create a macro where i can paste Columns of Option, Strike and Expiry in respective sheets on the left. I have written a macro. please advice the necessary changes <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Sheet1 Option Strike...
  8. M

    populate values in a cell based on date criteria

    Hi All, I required assistance on the below. Would be great if someone could help me out with it. I have the below file. https://www.dropbox.com/s/5wzide7bso...%203.xlsx?dl=0 I have to look at the below columns I - Usage , column L - Batch creation Date , M - Batch Expiry Date and N -...
  9. I

    Need to know expired qty based on my consumption data

    Dear Team, I have problem in finding expiry stock, I have a file contain two sheets, First sheet shows the batch wise stock with expiry dates and the second sheet shows month wise consumption, for example I have first batch expiry in June-2019 with the qty of 1000, and my stock consumption in...
  10. B

    Date on expiry of 6 calendar years

    Hi board members, I am sure someone can assist me please. I have a date i.e 08/01/2013 (dd/mm/yyyy format). In an adjacent cell I need to work out a date that is 6 years following the expiry of that current calendar year. So 08/01/2013, will show 31/12/2013 + 6 years = 31/12/2019 Many thanks...
  11. B

    Setting up the traffic light system within Excel

    I want to setup a spreadsheet with a list of mandatory courses that should be completed every 1 to 3 years and I would like to setup a traffic light system against each course listed so that:• When the course has been completed the cell for that particular course is 'Green'; • When the course is...
  12. M

    Cell Gap Issue ( Expiry Date )

    i have problem, when we export file into excel format from software, expiry date did not completely copy in excel format after page break . Data is too lengthy so how i can copy quickly same expiry copy in column B. now i am filling manually this Gap. sample is below: A...
  13. H

    Help - lost in big formula

    Hi everyone, I got lost trying to do a formula... Hope you can help me! I have 3 worksheets: <colgroup><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>...
  14. F

    Find expiry date and informing if cheque near to expiry

    This is the formula i am trying to get to work : =IF(COUNTA($L3)=1,"Delivered",IF(EDATE($I3,6)<=TODAY(),"Expired",IF((EDATE($I3,5))<TODAY()-30,"Near expiry","Pending"))) I just want to get this part to work fine : IF((EDATE($I3,5))<TODAY()-30,"Near expiry","Pending") The cheque date is in I...
  15. M

    Trying to construct an equipment-tracking spreadsheet that can display CURRENT, EXPIRING, EXPIRED by comparing a given date to today's date

    Hi everyone, I am trying to put together what I feel is a reasonably simple spreadsheet but my complete lack of experience with Excel is hindering me to the point where I'm struggling to even know what terms to Google in order to learn more - I apologise if this is very basic information that...
  16. B

    Training Excel Spreadsheet or Database

    Hi Folks, I know this is a excel forum but I really needs some guidance. I am in need of creating a training database. I didn't know whether their is a forum for databases like their is for excel so I thought I would just throw out the question. I am wanting a database to record training...
  17. M

    Highlight all jobs belonging to one client

    I have a spreadsheet with a list of jobs and the client. Any job that has an order has an expiry date of 10 years, anything else has an expiry date of 1 year. Any job that is still in date has been highlighted Green using conditional formatting. I would like to highlight all rows with the same...
  18. C

    Message Box to show expiry dates, when work book opens up

    Hi Guys, I have a database with Passport and License Details, with expiry dates. I have conditional Formatting in a certain column to show the dates that are about to expire within the next 15 or 30 days. And cells A1 in both sheet show ALARM or NONE to indicate that there are some expiry...
  19. V

    Filter Dates In Pivot More Than 3 Months Old

    Hello, I'm trying to use VBA to filter an OLAP Pivot Table for all dates that fall three months before the current date. the dates are in the dd/mm/yyyy format and there are hundreds of unique values so I've no idea how to do this. This is is an example from the macro recorder...
  20. css0911

    Copy data to new sheet on meeting criteria

    Dear All Please help me in this scenario. I have a master data sheet. Sample as below. <tbody> A B C D 1 Input Date 20/01/2018 2 Sr.No. Emp. Name Gate1 Gate2 3 1 Thomas 20/01/2018 01/02/2018 4 2 Bobby` 10/03/2018 20/01/2018 5 3 Kim 20/01/2018 20/01/2018 </tbody> Column...

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