# Days Overdue

#### Ben_Holmes

##### Board Regular
Hi,

I want to use a function which calculates how many days an audit is overdue.

In Column J I have if Audit has been complete Input = Either Yes or No

In Column H I have the date which the audit should be complete Input is the date.

In Cell C1 I have todays date.

Obviously if the Date is in the future it is not overdue.

Can any body help with a formula.

Its probably very simple but my head is not working!!

Regards

Ben

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### texasalynn

##### Well-known Member
Book3
BCDEFGHIJK
1Todaydate:1/18/2005AuditdueAuditComplete?PastDue
21/15/2005Yesno
31/12/2005Noyes
41/22/2005Nono
51/10/2005Noyes
Sheet1

HTH
texasalynn

#### Ben_Holmes

##### Board Regular
That Is Great - I have been playing with the IF but could not find an appropriate function.

THanks

I will beable to sleep tonight now!

Cheers

Ben

Replies
7
Views
659
Replies
1
Views
114
Replies
1
Views
110
Replies
6
Views
375
Replies
2
Views
104

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

1,151,589
Messages
5,765,308
Members
425,272
Latest member
Umba

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back