MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by jake on December 14, 2001 11:25 AM

=L9-today()

This works, unless I'm misunderstanding the question. Also, make sure you the cell with the above formula as general, not date.

Posted by Noir on December 14, 2001 1:27 PM

:Jake, sorry to confuse you. In a nutshell, i am looking to (1) find the number of days between 2 dates and (2) Have that number count down (eg:14,13,12,11,10,etc) until we get to the next payday which would make the number show as "0".

I tried your suggestion, hard to tell if it will work or not.

Posted by Jake on December 14, 2001 2:22 PM

this formula will give you the number of days between your pay dates when the current date is less than the earlier pay day, BUT if the current date is after the earlier pay day it gives you the number of days until the next pay day. kind of a long winded explanation, sorry...

=L9-IF(TODAY()<C9,C9,TODAY())

: =L9-today()