Calculate Days from the Due Date

[Mali Heena]

Hi,

Can anybody help me to solve my problem

I want to calculate Past Due Days from the Due Date

for Example : Due Date is 18/05/2012 so the Days from the these date is 30 days due

I want formula in Excel2007

[Spencer101]

Hi.

Presuming your "due date" is in cell A2, put the following formula in another cell.

=TODAY()-A2

Does that do what you're asking?

[Mali Heena]

No it's not working..i had already try it

i want past due days from the due date..

[Spencer101]

You will need to provide an example workbook showing what it should look like AFTER.

[Mali Heena]

For Example:

Invoice Date : 18/02/2012

Due date is 90 days from the Invoice Date : 18/05/2012

today is 22/06/2012

i want days between 18/05/2012 to 22/06/2012

[Spencer101]

As far as I can see, the attachment does what you're asking, but it's exactly the same formula as I put in my first reply.