Days Overdue

[Ben_Holmes]

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

 

[texasalynn]

how about this

Book3
	B	C	D	E	F	G	H	I	J	K
1	Todaydate:	1/18/2005					Auditdue		AuditComplete?	PastDue
2							1/15/2005		Yes	no
3							1/12/2005		No	yes
4							1/22/2005		No	no
5							1/10/2005		No	yes
Sheet1

HTH
texasalynn

 

[Ben_Holmes]

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