Hi all. I hope someone can help. I have been trying to work this out for quite some time now.
I have a spreadsheet set up to work out deadlines for tasks to be met.
The problem I am having, is that I want it to account for extra holidays/non-working dates and for it to add extra days on to compensate for the days lost through those extra non-working dates. I know I will need to input those dates to account for somewhere, but have no idea how to incorporate it into a formulas so that it works it for me.
My current formulas is very simple and does work, but obviously does not account for the extra days, and although I could add them on myself, I would like to be in a position not to have to, as the amount of dates that I have to account for are far too many. Also, this sheet is to be accessed by quit a few people, so I need the data to be accurate due to the fact that the deadlines are legal deadline.
This is my current formula: =IF(ISBLANK(B2),"",(B2 +40)
Please can someone help? I would appreciate any help and advice.
Many thanks
Looloo
Bookmarks