问题描述
我有一个包含开始日期、结束日期和完成百分比的表格.通过在 % 列中手动输入一个数字,代表任务的栏会变暗.我想要做的不是表示完成百分比,而是显示从今天开始到结束日期还剩多少时间.
I have a gant with start date, end date, and % complete columns. By manually entering a number in the % column the bar representing the task gets shaded. What I want to do is instead of representing % completed, I want to show how much time is left before the end date from today.
Start End % Time remaining from TODAY()
i.e. 12/01/2014 03/15/2015 (End date has not yet occurred)
12/29/2014 12/29/2014 (Task was started and finished this day)
推荐答案
假设您的结束日期在 B 列中:
Assuming your end date is in column B:
=IF(TODAY()>=B2,"Done",CONCATENATE(B2-TODAY(),""))
这将显示剩余天数.如果您想要花费的时间百分比,请使用
This will show you the number of days remaining. If you want the percentage of time spent, use
=IF(TODAY()>=B2,"Done",MAX((TODAY()-A2)/MAX(B2-A2,1),0))
并将单元格格式化为百分比.
and format the cell as a percentage.
这篇关于如何计算给定开始日期、结束日期和 TODAY() 的任务完成百分比的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!