+ Reply to Thread
Results 1 to 2 of 2

Uk Bank Holidays

  1. #1
    Registered User
    Join Date
    08-15-2005
    Posts
    8

    Question Uk Bank Holidays

    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

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi HDV,

    Don't know whether this will help at all, but if you put a date in A2, it will calculate the UK Public Holidays for that year (any year). Let's know how you get on.
    Attached Files Attached Files
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1