日期计算 [英] Date Calculations

问题描述

我遇到了一些问题，想知道如何在表单中插入日期并在该日期添加一年。是否有人可以提供帮助？ 

I am having some troubles figuring out how to have a date inserted into the form and add one year to that date. Is there anyone that can help? 

示例： 

检查日期：7/12/2018

Date Inspected: 7/12/2018

截止日期：7/12/2019

Date Due: 7/12/2019

我希望能够使包装盒有一个公式，使截止日期为检验日期的一年。 

I want to be able to make the box have a formula to make the due date one year from the inspected date. 

预先感谢您的帮助。 

Thanks in advance for the help. 

推荐答案

对截止日期使用计算列并使用以下公式：

Use calculated column for Due Date and use the following formula:

=DATE(YEAR([Column1])+1,MONTH([Column1]),DAY([Column1]))

请详细说明下面的Claculated列：

Please fins more details on Claculated columns below:

https：// docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v%3Doffice.14)

https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

https://sharepoint.rackspace。 com / calculated-columns-tutorial

这篇关于日期计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！