Keith
Registered User.
- Local time
- Today, 09:25
- Joined
- May 21, 2000
- Messages
- 129
I am creating a holiday planner. The range A2:C5 in the example below is populated from a user form. The name is selected on the user form using a combo box getting its data from F2:F5. Once the start and end dates are entered on the user form I have code that calculates the number of leave days not counting weekends and bank holidays. An Add button then adds a row to the range A2
5
The function that I use in G2 is {=SUM(IF(A2:A5=F2,D2
5))}
On the user form I want to show the number of leave days taken in the current leave year (E2) when the name is selected on the user form. The leave year runs from 1st April until 30th March.

The function that I use in G2 is {=SUM(IF(A2:A5=F2,D2

On the user form I want to show the number of leave days taken in the current leave year (E2) when the name is selected on the user form. The leave year runs from 1st April until 30th March.
Attachments
Last edited: