# Formula to identify Overdue or Due based on dates

1. ## Formula to identify Overdue or Due based on dates

Hi all,

I wonder if someone could help me with a formula using If, And & Or? I'm struggling a little bit. I've attached an example, but it's basically to give a status of whether an action is "Due" or "Overdue" or neither, dependent on the date and/or colour of cell:-

Red = a date in the past = "Overdue"
Yellow = a date in the next 30 days = "Due"
Green = a date more than 30 days in the future = ""

2. ## Re: Formula to identify Overdue or Due based on dates

Try this in E2 and down:
=IF(AND(SUM(A2:D2)< =TODAY()+30,SUM(A2:D2)>TODAY()),"Due",IF(SUM(A2:D2)< TODAY(),"Overdue",IF(SUM(A2:D2) >TODAY()+30,"")))

3. ## Re: Formula to identify Overdue or Due based on dates

Thank you Belinda! It works a treat.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1