Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Guys,
I was wondering if anybody knew how to calculate a future date using the system date and time, and an existing "time remaining" variable that I have already calculated? So for example: I have worked out time remaining on a project based on a 'percentage complete' user input. I now want to show the user that his project should be completed on such and such a date (using the system date) Can this be done for times as well? e.g. Project A is 4 day project. It is currently 47% complete. The current date & time is [MM/DD/YYYY & HH:MM:SS] what date & time will the project be complete? thanks a million Kind Regards, Steve Chalom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with calculating date 6 months into the future | Excel Worksheet Functions | |||
Calculating a future date | Excel Discussion (Misc queries) | |||
Calculating a Date for the Future | Excel Worksheet Functions | |||
Calculating Clock start time in Excel | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |