是/否计算列类型的公式 [英] Yes/No formula for Calculated Column Type

问题描述

= IF（Fueler，" = Date（YEAR（[Fueler Date]）+ 2，MONTH（[Fueler Date]），DAY（[Fueler Date]））"，""）

=IF(Fueler,"=Date(YEAR([Fueler Date])+2,MONTH([Fueler Date]),DAY([Fueler Date]))"," ")

类型为是或否。我想知道是否有一种方法，如果没有选择，它会将失效日期留空。如果该框已选中，则表示它将显示距该日期2年的日期。否显示正确，但不是。
它通常会给我语法错误或只显示公式文本。感谢您的帮助，我也不确定这是否在正确的主题中。这是我在这里的第一篇文章。

The type is yes or no. I would like to know if there is a way that if no is chosen, it would leave the expiration date blank. If the box has a yes checked that it would display a date that 2 years from the date. The no displays correctly, but not the yes. It usually gives me syntax errors or just displays the formulas a text. Thanks for your help, I'm also not sure if this is in the right thread. It's my first post here.

推荐答案

尝试以下公式适用于您（只需删除日期之外的额外"="和引号）：

Try if below formula works for you(just remove the extra "=" and quotes outside the Date):

=IF(Fueler,Date(YEAR([Fueler Date])+2,MONTH([Fueler Date]),DAY([Fueler Date]))," ")

祝你好运，

Allen Bai

Allen Bai

这篇关于是/否计算列类型的公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！