如何在Excel中进行日期的级联添加
Excel 应按以下方式运行： 
我的开始日期尚不清楚。我正在寻求的优势是如果我更改开始日期。我希望 Excel 根据标准更新所有其他日期。计划之间不会有任何假期。星期六和星期日除外。
我尝试了 Workday 功能，但是，我无法跟踪上一行截止日期的剩余日期。
The excel should behave in the following way:
My Start Date is yet unknown. The advantage I'm seeking is If I change the Start Date. I would like the excel to update all other dates based on the criteria. There will not be any holidays in between the plan. Except the Saturdays and Sundays.
I tried the Workday function, but, I'm unable to track the remaining date from the past row's due date.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我想通了。这里是。我添加了一列名为“剩余天数”的列。其中
第一行的数字列
DueDate = 第一个开始日期 + 总计第一行的
RemainDays = NetWorkDays(1st startDate, 1st DueDate) - 总数 从第二行开始的天数startDate = if(前一行剩余 < 0.1, 工作日(上一个截止日期,1), 上一个截止日期)从第 2 行开始
dueDate = 开始日期 + 总计所有行都相同...从第二行开始
remainingDays = NetWorkDays(startDate, DueDate) - 总计 - 上一行截止日期Excel 很神奇...
I figured it out. Here it is. I've added one column called remaining days. Which is a number column
1st Row's
DueDate = 1st Start Date + Total1st Row's
RemainDays = NetWorkDays(1st startDate, 1st DueDate) - Total no. of daysfrom 2nd Row onwards
startDate = if(previous row remaining < 0.1, workdays(previous due date,1), previous due date)from 2nd Row onwards
dueDate = start date + Totalsame for all the rows...from 2nd Row onwards
remainingDays = NetWorkDays(startDate, DueDate) - total - previous row due dateExcel is magical...