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