Hi
I'm sure someone can help easily with this.
I have a spreadsheet in which a target date is calculated, plus the number of days it takes to meet that date and the day number I am on. At the moment I manually take off days to take into account bank holdiays and fiddle around with the sheet as and when I need to, but I understand this can be done for me.
My target date is my first date plus 20. ie =WORKDAY(C5,20)
The actual day number I am on when I check my sheet each day is
number of days taken is calculated by
=NETWORKDAYS(P5,TODAY()) - I then insert minus the bank hols each time I need to.
The number of days to reach the target is calculated by
=NETWORKDAYS(P5,F5) (again doing the number of bank holidays each time)
Any ideas how to insert a reference to deduct any standard bank holidays which I understand are inbuilt. I have Analaysis Toolpak installed already to get the dates, days I get already
Any ideas?
cheers![]()
Bookmarks