LinkBack URL
About LinkBacks
Hello All,
I have a sheet, in which it show me the list of material and days expiry, now help me with formula, if i enter a manufacturing date it automatically calculate expiry date, with considering the material.
Hello All,
I have a sheet, in which it show me the list of material and days expiry, now help me with formula, if i enter a manufacturing date it automatically calculate expiry date, with considering the material.
put formula in a cell formatted as date and the formula would be = manufacturing date + days expiry
And what will be formula??/
If i manufacturing date is in cell a2, and i want expiry date on an other cell
=if(a2=(today),match(material name), add the days
Whatever cell this is in will be the manufacturing part of the formula.
This will be the expiry days part of the formula.if i enter a manufacturing date
Pick a cell where you want the formula to be, format it as a date and then type = then reference the cell with the manufacturing date type + then reference the cell with the expiry date and type enter.I have a sheet, in which it show me the list of material and days expiry
Last edited by skywriter; 02-22-2015 at 02:36 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks