If I have a Due date in one cell, how do i count how many days will have
elaspsed beyond that date at month end in another cell.

Due Date = 6/1/2008

Past Due days: (answer should be 30)

Due Date - 5/15/2008

Past due Days (answer should be 46

You are counting days differently... in first example, you are including the
due date in your difference whereas in your second example you are not. Here
is the formula if you are not counting the due date in your difference...

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-A1

and if you want to include the due date, just add 1 to it.

Rick


"Belinda7237" wrote in message
...
If I have a Due date in one cell, how do i count how many days will have
elaspsed beyond that date at month end in another cell.

Due Date = 6/1/2008

Past Due days: (answer should be 30)

Due Date - 5/15/2008

Past due Days (answer should be 46

thanks, i meant to not count the due date. This works, perfect! Appreciate
your help!

"Rick Rothstein (MVP - VB)" wrote:

You are counting days differently... in first example, you are including the
due date in your difference whereas in your second example you are not. Here
is the formula if you are not counting the due date in your difference...

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-A1

and if you want to include the due date, just add 1 to it.

Rick


"Belinda7237" wrote in message
...
If I have a Due date in one cell, how do i count how many days will have
elaspsed beyond that date at month end in another cell.

Due Date = 6/1/2008

Past Due days: (answer should be 30)

Due Date - 5/15/2008

Past due Days (answer should be 46