In microsoft excel, how do you count down to a date, in such a way that excel updates everyday? EX - Excel counts down 30, 29, 28 ... until it reaches 20NOC08.
by 
loomimj
ANSWERS: 1
-
Put the target date in one cell (say, A1). Put the formula =NOW() in another cell (say, A2) In cell A3 put =INT(A1-A2). You could put something like ="There are "&INT(A1-A2)&" days until the target date."
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC