Excel 2007 : Formula for displaying Total Overdue entries.

**DonkeyOte** · 12-16-2010, 04:38 AM

Given use of XL2007 you could try using COUNTIFS:

=COUNTIFS(A:A,"<"&TODAY(),B:B,"")
modify ranges as appropriate

**noahsampeer** · 12-16-2010, 11:42 AM

I had something similar to that but that just gives me a date. More specifically 1 Jan 1900.

Again, I need it to count how many entries are overdue (A) and then look at the Completed column and count the number of cells with text (B) and then do A-B=C.

C is the number that I need displayed.

**DonkeyOte** · 12-16-2010, 12:52 PM

Format the cell containing the COUNTIFS function as General/Number and you will see 1 rather than 1 Jan 1900.

Dates in Excel are just Serial Numbers - 1 Jan 1900 being 1 - it is the format you apply to the cell that determines how that "number" is being presented (ie as a Date or as a Number/Decimal etc)

On a final note - please do not quote prior posts in their entirety - this clutters your thread and the board in general.

Thanks,