# UK Bank Holiday Calculator

May 2, 2006

I found a link to a website on one of the forum pages. I had a look in the website and it showed a formula for calculating when Easter falls - I didn't know it could be worked out, but it can!!

I therefore decided to investigate further. I picked up another formula to calculate the first MOnday in May and I have now put together a little spreadsheet that will calculate all bank holidays in the year entered in cell B1. It also takes into account additional bank holidays that exist when Christmas Day and/or Boxing Day fall on a weekend.

## Bank Interest Calculator

Dec 1, 2006

I'm an amateur to macro as I'm only in a low level class at a university... But I'm attempting to make a macro for a bank interest calculator. It asks your type of account(which then assigns an interest rate to it), how much money is in the account, and also how long th emoney will be in the account. I used a "Select Case" for the account types, but I seem to be struggling for it to work, it won't put the value of the total into the assigned cell, or it's just not computing it(as I get "0" each time I run it)...

Public Function BankCalculator()
'Bank Calculator for different accounts
'declare variable
Dim shtBank As Workbook, strAct As String, intMon As Integer, strLong As Integer, intTotal As Double
Set shtBank = Application.Workbooks("Bank Calculator.xls")
'input box for amount of money, assign address
intMon = InputBox(prompt:="How much money do you currently have in the account?", _ ......................................

## Game Points Bank Account (running Total For The Bank)

Nov 5, 2009

Sheet6

80You Need 18,000 Pts.IntermediateYour Credit is 0 Pts

Excel tables to the web >> Excel Jeanie HTML 4

i have a "Game Points Bank Account" that keeps track of the points users earn or spend in the game...what i need help is creating a running total for the bank..ive tried everything nothing works..

(this is actually like a traditional bank account)

each player starts with 10,000 points

*Row 8 is the only row to have formulas*

*Rows 9-11 are typed in to show my desired results*

Here is the point value "Ranking System" for Column T

Sheet6

Excel tables to the web >> Excel Jeanie HTML 4

## Can't Copy Bank Statement

Oct 12, 2013

So I want to copy my bank statement into excel, but when I do, rather than separating each line into a row of separate cells, it separate it into a column of separate cells. and it does this for each row in the same column.

So:
A1 is in the right spot
A2 should be B1
A3 should be C1
A4 should be A2
A5 should be B2
A6 should be C2
etc....

Any way I can sort this out at the touch of a button? (or a few buttons)

## Holiday Pay

Nov 16, 2008

I need a formula to compute holiday pay. I am having problems when there are two holidays during the month and the hire date of the employee is after the first holiday. For instance in November, November 11 and November 26 are holidays. If the employee is hired before November 11, he gets paid for the two holidays. If he is hired after November 11, he only gets the second holiday.

A B C 1 HOLIDAYS 2 HIRE DATE RATE/ 11-Nov-09 3 HOUR 26-Nov-09 4 5 10/15/2009 60.00 6 11/16/2009 60.00 7 11/28/2009 60.00 8

## Keep Track Of Bank Transaction In Budget - In And Out

Mar 19, 2014

Solution to keep track of bank transaction in a budget - both in and out

With:

=SUMPRODUCT(--(Table[[CAT]:[CAT]]=\$C5);--(Month(Table[[DATE]:[DATE]])=G\$3);--(Table[[IN]:[IN]]))

Table1:
DATE | CAT | IN | OUT
----------------------

The transaction CATegory and Date place the amount from table - column IN to the corresponding cell in my budget.
I would like my bank account to reflect both income an expenses from 2 columns in Table: IN and OUT

Workbook example: [URL] ...........

## Insert Bank Rows After Each Occurences

Sep 22, 2007

I want to insert two blank after each broker. I am copying each broker's information to another spreadsheet. each broker information may take several rows...after copy one broker information, I want to automatically insert two blank rows...how can I do that in VBA excel?

## Accessing Bank Balances Automatically With Excel?

May 31, 2014

Is it possible to have my Excel cash flow sheet access my bank checking account and automatically update with my current balance?

## Temporarily Hide Transactions In Bank Statement?

Feb 3, 2014

I have downloaded some of my bank statements in excel format but they are just static data - ie, they are just numbers in boxes and the BALANCE column does not react when I take out a transaction.

I have put in a formula for the BALANCE column so it does now take its value from the previous day plus or minus transactions, but now I want to do additional things.

- How would I, for example, categorise several transactions as "HOLIDAY" [URL] ....... and then temporarily make them disappear so that I can see the effect of that on my balance? I can see how to hide/unhide transactions but that doesn't actually seem to have any impact on the balance column.

- Second query: how do I make my current spreadsheet a template so that when I download the next bunch of bank statements I can just apply all the formulae in this one to it?

## Bank Transactions - Grouping / Totaling Like Titles

Jun 1, 2014

I'm trying to group a year's worth of bank transactions. The initial data that was cut from pdf files is a date, payee and amount

1) how can I search down col A and give the sum of all like Payees, then total each set of similar payees? Maybe if first 6 characters match, then total until it comes to a different set.
Total each set.

2) then, I need to assign a category to each set of payees, so if contains usps, then add category "postage"

3) formula to find all postage totals and combine for a grand total per category.

usps15.23postage
usps14.32postage
usps5.23postage
fedex5.25postage
fedex10.22postage
shell45.28fuel
shell99.38fuel
qt27.38fuel
qt44.88fuel

## Holiday Pay Calculation

Jan 17, 2007

I have a problem with a cell displaying the correct number of days.

We work a 38 hour week and therefore each day is 7.6hrs

I have a start date and current date and calculate the number of days employed. I know that each day employed is worth 24 minutes, so over the year it calculates to 20 days per annum.

as I have not entered all the hours taken off yet, my current holiday entitlement is 767:04 (hh:mm).

when I process this on the calculator it tells me I have nearly 101 days holiday due, but I can not get excel to display XX:XX:XX (DD:HH:MM)

What would like to know is how many days that equates to using the 7.6 hour days

## Autofill Dates Excluding Bank Holidays & Weekends?

Feb 26, 2014

Is there a way to autofill dates in excel to exclude weekends and bank holidays?

## Find Specific Withdraw Entries From Bank Statements

Jan 6, 2010

I use online banking for paying my monthly bills. I get different confirmartion for each pay transection. Pls look attached Excel file. Now I want to find specific bills expense with amount from all my 12 months bank statements. How can I get this task done.

Note: Each time get different confirmation which appears on my bank statement beside paid bill name. for example January 2009 statement GAS Z8A.... Feb 2009 GAS S2W. I hope this clarify. What I have to do if I want to get all my 12 months GAS money withdraw from bank statement. I use csv file for bank statement.

## Loan Formular To Capture Overdraft Bank Facility

Aug 30, 2009

how I can solve the issue of creating a spreadsheet (similar to an amortization one) that could deal with unequal re-payment regime as well as unfixed (anytime of the month) payment periods.

## Staff Holiday Analysis?

Dec 17, 2012

My boss wants me to take the holiday info from SAGE for 80 employees and create a record on excel. He wants to know what holidays each employee has taken and is due to take throughout the year. As each employee works a different amount of hours and a different shift pattern, SAGE records their holiday entitlement in hours rather than days. I have attached an example of one employees details and if come up with an excel document containing similar information for 80 individuals - all starting on different dates and all having a different amount of holiday entitlement. He wants to be able to look at each employees record for the year and see not only holiday data but sick days too. I don't know where to start with this - I've thought about creating a workbook with 80 pages and create a 12 month calendar for each individual with days off marked on it?

Nov 4, 2007

At my job, employees accrue X hours vacation per 2 weeks worked. This makes it difficult for everyone to plan vacation (IE - will I have enough vacation in January to go on vacation for 2 weeks?) I'm trying to create a calendar in my spare time to help out, but it's turning out to be quite a bigger task than I've ever attempted in excel. Therefore, I'm coming here hoping someone will point me in the right direction.

I found this:
[url]
It does the majority of what I need. However, as it costs money, I'm afraid they've locked down editing of things and I won't be able to add functionality to it. It'd be annoying paying them and then finding out I can't add vacation days earned, as the spreadsheet is locked.

Features I'd like added to the above program:
- Add another checkbox (or similar) to show hours of vacation accrued, as well as an original date and hours to start counting from.
- Highlight days corresponding to what kind of day it is. Weekends = red, holidays = green, vacation = yellow, etc.

What I started with:
[url]
This gives me a calendar with the dates in the right place. I've created macros to identify holidays dates. It's starting to get pretty annoying using conditional formatting on everything to highlight days. Especially since I have to do it for each of the 12 months, as it has a hard-coded month cell in there.

## Holiday Roster Templates

Aug 19, 2007

where I might find some?

## Excel 2003 :: Templates For Personal Bank Account Management

Dec 10, 2013

I really need a comprehensive excel file which can manage my bank account id, savings, transactions, withdrawals, transfers etc etc. could be better if it can show any graphical interface with charts as well. I am willing to have a file so that i can manage more than one bank accounts. ( Excel 2003 is my version)

## IF Formula Missing Something: Extra Holiday

Jan 21, 2010

using IF formula [ =IF(SUM(C3),LOOKUP(DATEDIF(\$C3,NOW(),"y"),(0,3,),(0,3,)),"")] holiday sheet after 5 years service employee get 3 days extra holiday trying to in E3 to add 3 days to holiday entitlement to take from 16 days to 19 days

## Creating A Staff Holiday Spreadsheet?

Sep 17, 2013

Currently I'm working on functionality in my staff holiday spreadsheet and I've come up with this amazing idea for a calendar overview for month by month.Now the sheets I currently have is summary and jan to dec.

I plan on adding the sheets Jan (Cal) to Dec (Cal) now this is when my idea gets nifty - The calendar view will import the information from the month table and will show it on the calendar.

For example X has 1 holiday in July for the 20th - this will show up on the calendar as "x on holiday", I'm still working with spreadsheets so I'm not sure if excel is powerful enough to do this - but is this actually possible?

## Holiday Program - Export To Ms Outlook

Oct 10, 2008

i have this holiday program (this is linked to networked excel spreadsheets in the origianl) and what i want to do is create a macro that will create an appointment in microsoft outlook calendar for each date everytime i select the cells and click the button with the persons name in the subject. is this possible?

## Holiday Calculation In Gantt Chart

Jul 8, 2014

Gantt chart to calculate holidays, it now only calculation weekends only, file can be downloaded from here.

## Workday Holiday Trigger Date

May 21, 2009

I am trying to work out a formula calculating dates.

basically a piece of work / report is due for completion twenty working days from a trigger date. And I need the formula to calculate this due date. Im using the workday function, which calculates a date using the number of working days given after the trigger date.

this would work fine, except that the trigger date needs to be included in the calculation (inclusive). I have tried changing the value for the number of working days to nineteen, which would logically give the right answer (20 days including the trigger day). BUT the bloody thing doesnt work, because the trigger date can be on a weekend or holiday!! so then it calculates 19 days (as it should) but the result is wrong because the trigger day isnt included (as its a holiday/weekend).

## Worksheet Update For Holiday Spreadsheet

Feb 17, 2006

I need to have all the information in one workbook for all 100 employees and still provide an individual report for each user and an overall report. In the attachment is a "Summary" and "Calendar" sheet these are the original individual files. summary contains personal information and the "calendar" tracks absence and holiday and the totals returned to the Summary sheet. I think what I need is a Master worksheet that has all the information in for each employee pre row and to have a "calendar" input/change/ call worksheet sheet to call an individual detail, this would also update the master worksheet with any changes.

## Userform Interface For Holiday Planner

May 29, 2008

I have one workbook with two worksheets (Jan-JUly and Aug-Dec). I am using a userform to add data into worksheet ("Jan-July"). But I do not have any clue - How do I update the other worksheet (same data like name,join year etc)worksheet("Aug-Dec") at the same time. I used two worksheets because worksheet doesn't support 370 columns, and to make my life easy. UserForm add data into Column A to M (worksheets Jan-July), rest is done manually. I have also attached the file.

Dim dataCheck, eMsg As String
Dim strLastRow As Integer
Dim x As Double
strLastRow = xlLastRow("Jan-July")
'get Last Row
With dataInput
'dataInput name of userform
If (.fNameBox.Value <> vbNullString And .fNameBox.Value <> vbNullString And .joinYearBox.Value <> vbNullString) Then
'textbox validation value can not be empty......................

## Excel 2010 :: Counting Bank Cells Based On Changing Criteria?

Oct 30, 2013

I am using Excel 2010.

BTES worksheet:
acct# Oct-13 Nov-13 Dec-13
13245 850
12458 850
45864
12385 1500

MainList - F2= (current month)

Based on the current month (which I planned on typing in) on the MainList worksheet I need to count how many blank cells are in the table above. The information above is on a separate worksheet but I can change that in the formula. Every month gets a new column.

This is what I have but its not working correctly: =SUMPRODUCT(--(BTES!AD1:BQ18=F2),--(BTES!AD1:BQ18" "))

## Automatic Finish Date & Time With Lunch Break And Bank Holidays

Feb 13, 2010

I would like a solution for the automatic calculation of the end date and end time for project tasks. I have already spent hours on the issue, thanks for any help on this.

The parameters are:
A1 = Start time 08:00
B1 = End Time 17:00
A2 = break lunch 12:00
B2 = back from lunch 13:00

A5 = start date 01/03/10 (entered manually)
B5 = start time 10:00 (entered manually)
C5 = duration 02:00 (hrs entered manually)
D5 = "end date" >>> (to be calculated exluding breaks and holidays)
E5 = "end time" >>> (to be calculated exluding breaks and holidays)

the next line should be filled in automaitically according to the hours needed and the previous end date & time

A6 = "start date" >>> (after line 5: to be calculated exluding breaks and holidays)
B6 = "start time" (after line 5: to be calculated exluding breaks and holidays)
C6 = duration 14:00 (entered manually)
D6 = "end date" >>> (to be calculated exluding breaks and holidays)
E6 = "end time" >>> (to be calculated exluding breaks and holidays)

and so on for every new line down.

## Conditional Formatting: Dates Show When On Holiday

Nov 4, 2008

I am creating a register and have got a worksheet with everyone name and dates across the top, the dates are automatically created by entering one date, the dates are weekly. But i want to show when we are on holiday, could i do this by using conditional formatting and if yes, how and if no how else can i do this.

## Excel Automation On Tax Free Period / Holiday?

Oct 9, 2013

Any excel formulae to build in into my financial model for tax free period/tax holiday, eg for first 6 years, the project company no ned pay tax? it is best if the formulae can bring flexibility for user to change the no. of years (tax holiday).

## Indicating A Holiday AND Change The Color OF Cell

Dec 6, 2007

I'm trying to create a spread sheet for our staff holidays. I have the year dates all mapped out across the sheet, and the staff names running down the first column. I would like to do the following:

1. When an "H" is put into a certain day, indicating a holiday, the cell color changes to i.e. blue. The color will be different for each staff member. We have four members of staff! (big company).

2. The "H"'s are totaled up for each member of staff to indicate how many days holiday they've had. Or if the staff member has 20 days per year, 20 is in a cell next to their name, and each "H" takes a number from that, i.e 19, 18 etc.

Sorry if I sound like a complete noobie!