Excel Auto Calculating Dates + Delay

funkylad20 | 15:45 Wed 23rd Sep 2009 | Computers

1 Answers

OK, new excel challenge...

I have a cell with a date in. Say A1, date being 01/01/2009.
I want cell A2 to auto-fill in with a date 15 days after the date given in cell A1 (working days excl bank hols). I also need to do a similar thing later on, with a 6 week time-frame.

I vaguely know about codes for dates and WORKDAY function, but cannot suss out the finer details of this formula...

prev

Excel - text in cells, blank, IF Function

next

Outlook Express

Answers

Only 1 answer

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

I think you need to look at NETWORKDAYS and you will need to create alist of non-working days such as bank holidays etc

Only 1 answer

Do you know the answer?

Excel Auto Calculating Dates + Delay

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.