Hi Mark
In my previous reply I eroneously said that it could not be done without
the help of a macro. I also looked at the answers given by other
contributers, and theirs would also work.
I have found a neater way of doing it, which does not use any "IF"
statements, and would not depend on the dat format being used on your
computer.
As in your given, Cell C6=Today()
But then cell D6=EOMONTH(C6-xx,0)+xx
Where xx=the day of the month you want to count down to, which in your
case is 21. The only restraint is that xx cannot be greater than 28,
else you will have problems with February.
And in Cell A6=D6-C6
Hope this helps.
At Neethling
Cape Town.
Mark Rode <[log in to unmask]> wrote:
I would like to have an Excel formula where as
C6=(TODAY)
D6=7/21/09
A6 =D6-C6 but....
A6 counts down the days from the 21st of the month. What I want it to
do is when A6 reaches 0, it changes D6 by increasing the month by
one, thus starting a new month countdown. How do I accomplish this. Thanks
--
___________________________________________________________
QOTW: I have a tip that can take 5 strokes off anyone's golf
game. It is called an eraser.
--Arnold Palmer
"Hold No Punches.." Rode brings you great shareware/freeware
programs with his honest opinions in this weekly column.
http://freepctech.com/rode
|