# formula to figure out if 90 days past due

• What would be the formula I could use to see if something was 90 days past due? I've entered the date of 4/30/05 in column A1 on the spreadsheet and 90 or more in column B1. I'd like the formula to calculate if something was 90 days or greater past due.

Thank you

• Re: formula to figure out if 90 days past due

Hi,

Try the following formula

=IF(TODAY()-A1>90,TODAY()-A1,"")

It will show the number of days overdue, but only if it is greater than 90

hth
xl guru

• Re: formula to figure out if 90 days past due

Try this

=IF(N12-N13>90,"overdue",FALSE)

Where N12 is the latest date, and N13 is the original date

Alastair

Einstein:
Things should be made as simple as possible, but not any simpler

Be sure to check out TemplateZone for all your Microsoft Office Needs.

• Re: formula to figure out if 90 days past due

Hi,

I wasnt sure if you were to count working days (i.e. monday - friday), or just ALL days... here are two formulas you need anyway.

'this is for caluclating working days between two dates
=NETWORKDAYS(A1,TODAY())

'this is for calulating all days (including Sat and Sun) between two dates.
=DATEDIF(A1,NOW(),"D")

NB - you might need to Add in the Analysis Toolpak to get the Networkdays function to work.

You can then apply conditional formatting on the cell if more than 90 days.

Ger

Check out our new reputation system. Click on the Like button under the post!
_______________________________________________

[SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.

Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

The BEST Lookup function of all time

Dynamic Named Ranges are your bestest friend[/SIZE]
_______________________________________________

• Re: formula to figure out if 90 days past due

I'd like to thank all who replied for your help. I have found the answer to my problem with your help.