LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How do I add a number of working days to todays date to get a dead

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel add working days to a date to result in another date? cwalrus Excel Worksheet Functions 1 May 16th 06 07:27 PM
Number of days between 2 dates, if end date is blank assume todays JulesM New Users to Excel 1 March 1st 06 12:41 PM
How to put todays date in one cell then the next cell adds x days trekkies Excel Discussion (Misc queries) 1 January 6th 06 04:26 AM
date (minus) date = working days diff jjj Excel Discussion (Misc queries) 3 December 6th 05 03:16 PM
calculate number of working days philc Excel Worksheet Functions 2 June 1st 05 07:48 AM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"