Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
I'm looking for a function, similar to NETWORKDAYS, but that will allow me to add a number of working days to todays date to generate a deadline, hopefully I'd like to include Holidays too, just like NETWORKDAYS can, so based on established timescales, I can generate a date the job will be completed by. For instance, If Cell A1 has todays date, and A2 has the number of working days a job takes to complete, I'd like a function for A3 that will work out what the date will be when the job is complete. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel add working days to a date to result in another date? | Excel Worksheet Functions | |||
Number of days between 2 dates, if end date is blank assume todays | New Users to Excel | |||
How to put todays date in one cell then the next cell adds x days | Excel Discussion (Misc queries) | |||
date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
calculate number of working days | Excel Worksheet Functions |