如何根据剩余天数自动计算开始和结束日期计算？

I have a table like so:

我有一张这样的桌子:

     A           B         C
----------------------------------
| Days Rem |   Start  |   End    |
|----------|----------|----------|
|   0.94   |  Mar 31  |  Mar 31  | 
|----------|----------|----------|
|   0.38   |  Mar 31  |  Apr 01  |
|----------|----------|----------|
|   0.75   |  Apr 01  |  Apr 01  |
|----------|----------|----------|
|   0.5    |  Apr 01  |  Apr 02  |
|----------|----------|----------|
|   1.5    |  Apr 02  |  Apr 03  |
|----------|----------|----------|
|   1.0    |  Apr 03  |  Apr 04  |
|----------|----------|----------|
|   1.0    |  Apr 04  |  Apr 07  |
----------------------------------

What I would like to do is to only have to manually populate the first Start value and then have End values and the next Start values automatically increment accordingly. At the moment, all of my start dates are manually entered, and my end dates are calculated like so:

我想要做的是只需手动填充第一个Start值,然后使End值和下一个Start值自动相应增加。目前,我手动输入了所有开始日期,我的结束日期计算如下:

=WORKDAY(B1,A1)

It'd be cool to do this, because then I could introduce a Lag column to influence the Start Dates accordingly...

这样做很酷,因为我可以引入一个Lag列来相应地影响开始日期......

I'd like to know the best way to do this if possible.

如果可能的话,我想知道最好的方法。

1 个解决方案

#1

I'm assuming that your 'Days Rem' column is populated manually, so the easiest way I see would be to have each cell in the Start column reference the preceding cell in the End column.

我假设你的'Days Rem'列是手动填充的,所以我看到的最简单的方法是让Start列中的每个单元格引用End列中的前一个单元格。

So you would have B2=C1, B3=C2, etc.

所以你会有B2 = C1,B3 = C2等。

#1