Lolita asked in 電腦及互聯網軟體 · 1 decade ago

Excel autoupdate remaining date

例如:

有一個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相減?

2 Answers

Rating
  • 1 decade ago
    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
  • 1 decade ago

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

    下拉

Still have questions? Get your answers by asking now.