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
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