Counting Days

B

Belinda7237

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
B

Belinda7237

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top