Repost: Looking for formula to count-down days
Posted by Noir on December 17, 2001 1:54 PM
((Thanks to the guys that tried to help but, no suggestions seemed to work)).
My spreadsheet shows the dates (normally 2) on which we get paid each month. (eg:1st payday "in cell C9 12/1/01, next payday, "in L9" 12/15/01. Number of days between "in H9"is 14.
I would like to have that 14 days decrease by 1 each day (eg:14,13,12,11,etc.) until we get to the next pay date, then the number would show as 0. (Note:I use =now()"in cell G4", can this be used to help decrease the days?)
Thanks,
Noir
Posted by Jacob on December 17, 2001 2:10 PM
Hi
Try this
Lets say the taget date is in A1
Then
In B1 type = if(A1-today()<0,0,A1-today()
Modofy to the appropriate cells.
Jacob
Posted by Aladin Akyurek on December 17, 2001 2:28 PM
Still unsure, but what about entering
in H9: =TODAY()-L9
Aladin
=======
Posted by Noir on December 18, 2001 6:58 AM
:Thanks Jacob, i think it will work!!!
Noir
