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

[Pam K]

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

 

[RonB1111]

Assuming your start date is in B2, try:

=MAX(B2+90,TODAY())-TODAY()

and format the results cell as general

 

[Cosmic Wizard]

Assuming your start date is in B2, try:

=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"))