expiry

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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