# days remaining based on a 90 day deadline and it updates daily

#### Pam K

##### New Member
My projects at work are on a 90 day deadline from a start date
Each project has it's own start date
I use an Excel spreadsheet to keep track of each project (one per row)
One Excel column indicates the start date
Based on that 90 day deadline, I need a formula that will tell me how many days are remaining to complete that project.
I need to take into consideration that each month doesn't have the same amount of days in it
I also need the spreadsheet to update that number of days remaining every day when I open the spreadsheet.

Any help would be greatly appreciated.
Pam

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Assuming your start date is in B2, try:
Code:
``=MAX(B2+90,TODAY())-TODAY()``
and format the results cell as general

Assuming your start date is in B2, try:
Code:
``=MAX(B2+90,TODAY())-TODAY()``
and format the results cell as general

Hi Pam, here is a formula which I saw in another thread: it may help you as it also shows how many days a project is behind or whether you need to start it or not.

Hope it helps,if not RonB1111 formula is great also.

=IF(B2-TODAY()>90,"Not past due",IF(B2>=TODAY(),"Due in "&B2-TODAY()&" days","Overdue by "&B2-TODAY()&" days"))

Replies
4
Views
438
Replies
5
Views
607
Replies
3
Views
443
Replies
1
Views
151
Replies
3
Views
162

1,196,239
Messages
6,014,166
Members
441,807
Latest member
sjkenjalo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back