Excel autoupdate remaining date

Question

例如:

有一個column, 我入左kill date, eg. 2007/9/7

唔知excel有冇一個function, 可以自動detect到今日既date, eg. 2007/9/5, 然後同kill date相減, 即2007/9/7-2007/9/5=2 days?

Update:

例如:

有一個cell, 我入左start date, eg. 2007/9/7

有一個cell, 我入左end date, eg. 2007/9/10

然後kill date 同start date 相減, 即3 days

formula係點呢?

又例如.

今日已經係2007/9/8, 有冇一個combined function, 可以自動detect今日既date, 然後同kill date相減? 而未到start date既data, e.g2007/9/6, 可以自動同kill date相減?

Answer 1

Favorite Answer

Try this, in cell A1 enter you kill date [2007/09/07]

in cell B1 type [ =(A1-TODAY( )) & " Days" ]

And you will find your result in B1

Source(s): myself

Answer 2

=DATEDIF(TODAY(),A1,"d")

下拉