If functions and date

Hi everyone,

I am trying to create a function that will tell me when something is past due.

I have a excel document for my office's accounts payable, it has a master sheet where all of the companies that we pay are listed, and they are linked so that you can click on the name and it will take you right to the page to see a more detailed breakdown.

I am trying to figure out how to make something on the master page to tell me when something is due, even if it just makes an X when it is past due.

There are about 73 worksheets in this document and each worksheet contains many dates.

Is this even possible for me to do something like this? If not does anyone have any suggestions?

Thanks!

Possibly with Conditional Formatting, you can colour the cell(s) that are past due...

Select date cells and go to Format|Conditional Formatting

apply:

Cell Value is >> Less Than >> =TODAY()

Click Format and choose colour pattern.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

This is the formula I would apply in C4:

=IF(AND(MIN(INDIRECT("'"&A4&"'!C:C"))>0,MIN(INDIRECT("'"&A4&"'!C:C"))<TODAY()),"X","")

based on if earliest date in column C is past....then enter an "X"

but make sure your Company name matches the Sheetname... in the sample you have a space but tab does not....

See attached.

Well, Column A is your customer list.. I presume each tab has a corresponding Customer Name as the tab title... instead of just Sheet1, Sheet2, etc....

So as long as the word in column A is the same as the tab name for the corresponding link, then it should work?

Clearer?