Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers
Diogenes
Diogenes
May 2024
6:14pm, 21 May 2024
86,135 posts
  • Quote
  • Pin
Diogenes
Here’s something you clever lot might know.

I have a spreadsheet that tracks the number of working days between 3 different actions. To do this I have a table that lists all non-working days. This I populated manually for the last 6 months. However, some of the events I’m tracking go back much further than this.

Does anyone know of somewhere I could find and copy all the UK non-working days going back 3 years?
larkim
larkim
May 2024
6:15pm, 21 May 2024
24,236 posts
  • Quote
  • Pin
larkim
What do you define as a non-working day?
Diogenes
Diogenes
May 2024
6:16pm, 21 May 2024
86,136 posts
  • Quote
  • Pin
Diogenes
Weekends and bank holidays
um
um
May 2024
6:32pm, 21 May 2024
8,483 posts
  • Quote
  • Pin
um
Try networkdays(...)
If you set locale/region to UK, it should (as per MS!) take them into account

techcommunity.microsoft.com
larkim
larkim
May 2024
7:15pm, 21 May 2024
24,237 posts
  • Quote
  • Pin
larkim
I thought networkdays() only handled weekend days, with additional bh days add-able as a separate array?
Diogenes
Diogenes
May 2024
8:31pm, 21 May 2024
86,137 posts
  • Quote
  • Pin
Diogenes
Networkdays is what I’m using, but I had to set up an array for non-working days. Maybe I misunderstood and only needed to do the bank holidays, but I’m sure in my tests the formula was counting weekends as well.

The spreadsheet is on my work laptop so I’ll look tomorrow.
Diogenes
Diogenes
May 2024
8:32pm, 21 May 2024
86,138 posts
  • Quote
  • Pin
Diogenes
I’ve not seen any mention of that larkim, but you most certainly know better than I.
um
um
May 2024
8:49pm, 21 May 2024
8,488 posts
  • Quote
  • Pin
um
Should exclude weekends, and as per Larkim, needs an array of UK Bank Hols
quimby
quimby
May 2024
8:50pm, 21 May 2024
6,582 posts
  • Quote
  • Pin
quimby
I got very annoyed with Excel 365 today. If you have a shared workbook, it appears you can't hide columns just for yourself - it hides them for everyone. Really vexing when you just don't need to see some of them and it won't all fit on your monitor.
HappyG(rrr)
HappyG(rrr)
May 2024
9:13pm, 21 May 2024
50,050 posts
  • Quote
  • Pin
HappyG(rrr)
Excel 365 gives each user option to see only yheir own folders or everyone's. I think. :-) G

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,312 Fetchies!
Already a Fetchie? Sign in here