在使用vlookup时创建公式(有效停止)日期 [英] Creating Formula (Effective-Discontinue) Dates while using vlookup
问题描述
如果生效日期在结果列内,我需要一些帮助来创建一个有效的公式来帮助我将结果返回到一个字段中。如果中断日期还没有过期,还要计算公式。
I need some help in creating an effective formula to help me return a result into a field if the effective date is within the results column. Also want the formula to be calculated if the discontinue date has not expired.
以下是我正在寻找的内容的快照。
项目
Here is a snapshot of what I am looking to do. Project
如果生效日期是04/01 / 2015-04 / 30/2015并且仍在停止日期,那么T将仅返回。
(T通过查找该月份的零件号码的数量计算)
我希望这是清楚的。
Where as "T" will only return if effective date is 04/01/2015-04/30/2015 and still within the discontinue date. (T calculates by looking up a part number volume for that given month) I hope this is clear.
谢谢。
推荐答案
我相信这会做你想要的:
I believe that this will do what you want:
= IF(AND(A2< = DATEVALUE(4/30/2015),B2> = DATEVALUE(4/1/2015)),Your function here,) / code>
=IF(AND(A2<=DATEVALUE("4/30/2015"),B2>=DATEVALUE("4/1/2015")),"Your function here","")
您将摆脱您的功能在这里的引号,并将其替换为delta * vlookup公式。如果它有效,请接受我的答案:)
You'd get rid of the quotes for "Your function here" and replace it with your delta*vlookup formula. If it works, please accept my answer :)
如果格式化列标题,这只是给定月份的第一天(4/1/2015),您可以自动化公式,以便您不必在每个月的列中进行调整。
If you formatted the column heading so it was just the first day of a given month (4/1/2015), you could automate the formula so that you don't have to adjust it for each month column.
这篇关于在使用vlookup时创建公式(有效停止)日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!