So I’ve been thinking about all the requests that come to the forum along the lines of “I normally get paid on [Bank Holiday], when can I use Get Paid Early”.
And I had a slow day at work so I made a rough calculator in Google Sheets
If you want to know when a specific Pay Day will allow you to get paid early - pop the date in here:
It should go as far as all the bank holidays in 2023.
Any dates look wrong? Any feedback? Can you break it?
Working day before shouldn’t need a calculator. It’s just the working day before
I would agree but it does seem to come up enough so…
Yeah Google Sheets may not be the best way to do this, I’ve just realised.
Turns out everything is visible for everyone, all of the time.
And their data validation rules are not helpful.
Looks really nice! 
Did you have to do much manual work or was it simple to automate this in Sheets? 
I’ve written something like this in Python – my end goal is to throw Django around it and build a web interface so it’s friendlier and wayyy more accessible 
But this is as far as I’ve got so far 
(it fires a Slack webhook and prints something into a channel on Monzo’s Slack at 4pm on payday 
)
On a hidden sheet there is a long list of dates that looks like this:
And a 2nd list of Bank Holiday dates.
Everything except the “Date” column is done with a formula to calculate what “type” of day it is, and the nearest paid early date.
Then the front page just does a lookup against this data.
I was more curious how I’d answer the “how do you find the working day before”, using Excel.
This is amazing @BritishLibrary
Doesn’t matter if you’ve got a sheet to tell you, some fancy coding or even if it was built into the app to tell you the exact date.
They’ll still find there way to the forum, not search for anything and ask that same question, which was answered one post below the new one 🤦😂
I’m sure you’re right in that it will always come up. (Although building it into the app isn’t a bad idea …)
Though the other day I did write a comment on a wiki page along the lines of “How can we use more Community pages / Wiki posts to solve common problems”, so I guess this is me actually trying to add value to the forum rather than just being spammy about pens for once
I think its great that you at least had a go. Well done. R-
Pens are more interesting at least 
Thank u, I never know when I get paid 
That’s a sign you really don’t need the money
That’s a sign you really don’t need the money
All I’m saying is that next to TikTok, my #2 most used app is YNAB 
It should be the Friday because that is the working day prior to your pay day 
Assuming your employer has done the BACS set up properly, it should land on 4pm on the previous working day, which would be today, for Tuesday.
Ah fair, I didn’t spot the pre-empting question part of your reply
I can at least get why Bank Holidays cause a bit of confusion. Going from a Getting paid 4 days early seems… Unlikely.
And the scenario of “my pay day isn’t a bank holiday but the get paid early day is” just results in me doing this:
When someone joins and makes their first thread, both have to be approved now don’t they?
Instead of “your thread is awaiting approval” could they get a “While we’re reviewing your thread…” type thing?
Give them a link to this and then maybe half a dozen key topics that will help. The guide from @davidwalton about how to log in, how to contact support, how to/when to reorder a card. Those few probably cover a lot of the things newbies ask.
That’s a great idea - I wonder what the Top 10 most commonly asked questions are?
Maybe a sticky post in Help, with a wiki of the Top 10 questions too?
