我该如何计算“进度”？基于今天的日期，开始日期和预测结束日期的项目（％格式） [英] how can i calculate "progress" of a project based on today's date, the start date and the forecasted end date (% format)

问题描述

大家

我希望基本上以％条款显示.....项目进度基于我的2现有日期列

即"开始日期"是1月1日，"预测结束日期"是11月1日。

大约10个月。说今天是8月1日 - 然后是"进展"。应该是大约70％.....

解决方案

使用具有以下公式的计算列：

 = DATEDIF（[今天]，[开始日期]，"d"）/ DATEDIF（[结束日期]，[开始日期]，"d"）

请在此处查看示例：

https://www.interfacett.com/blogs/how-to-create-calculated-column-showing-difference-between-dates/

公式：

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v ％3Doffice.14）

希望这会帮助！

hi all

i want to basically show in % terms.....the project progress based on my 2 existing date columns

i.e. "start date" was 1st jan, "forecasted end date" is 1st november.

thats approx 10 months. say today is 1st august - then the "progress" should be approx 70%.....

解决方案

Use calculated column with the following formula:

=DATEDIF([Today] , [start date] ,"d")/DATEDIF([forcasted end date] , [start date] ,"d")

Please check an example here:

https://www.interfacett.com/blogs/how-to-create-calculated-column-showing-difference-between-dates/

Formulas:

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

Hope this will help!

这篇关于我该如何计算“进度”？基于今天的日期，开始日期和预测结束日期的项目（％格式）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！