Number of days btwn 2 dates (decrease by 1 each day?)
Posted by Noir on December 14, 2001 8:23 AM
My spreadsheet shows the dates (normally 2) on which we get paid each month. (eg:1st payday "in 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 until we get to the next pay date, then the number would show as 0. (Note:I use =now()"in G4", can this be used to help decrease the days?)
Thanks,
Noir