issue with adding weeks to the date

[matthewwookie]

Hi

I've got a problem where i have a list of dates, all of which i need to
at six weeks to. that bit isn't to tricky, however, some of the dates
could be either a saturday or sunday or bank holiday. If thats the case
it then needs to add a day or two to the six weeks inorder to get it
clear of a 'non working day' Also, if its around christmas, this issue
is increased as the bank holidays are next to each other.

Has anyone got any ideas on how to do this? theres about 14000 dates so
doing it by hand could take a while!!!

Thanks

Matt

 

[JE McGimpsey]

Take a look at WORKDAY() in XL Help. It's part of the Analysis Toolpak
Addin, so you'll have to ensure that that's loaded (Tools/Addins...)

=WORKDAY(A1+41,1,<holidays>)


matthewwookie