Completed

Leave Planner

Hi my name is Nelson Mwaura, I work for a HR Consultancy where we provide HR Partnered Service and Outsourcing to clients in multiple and different industries.

Currently, I am developing a 2021 leave planner for one of our clients. However, I got stuck while trying to add some formulas that will ease the results I get. I have attached the excel file in which I would like your team's assistance in incorporating these formulas.

The purpose of this excel file, is to enable managers schedule and plan their employees' leave by inserting information under (Columns P to Columns NO). I have also added a key to specify which letters can be added and what they stand for in the worksheet.

Now with this, I would like some assistance on adding certain formulas under certain columns as follows:

In Column F; I have inserted a formula that describes the source of information for each row. For example in row F5, it reads its data from row $N5:$CZ5. However I would like you to add a formula which also includes information from row E5. I would like the formula to specify if the value under row F5 exceeds the value under E5, then the result should be exactly similar to the value in E5.

In Column K; I have inserted a formula to express the source of information for each row which is from N5:NO50. However under each row, for example under row K5, I would like to add a formula which avoids double counting if the value has already been counted in row F5.

Could you please assist in incorporating these formulas under each respective rows and columns.

Skills: Excel, Data Entry, Data Processing, Excel VBA

See more: organizational leave planner board, adding integers worksheet generator, leave planner 2012 excel spreadsheet, staff leave planner 2012, staff leave planner, excel staff leave planner, staff leave planner 2012 excel, employee leave planner availability excel, excel employee leave planner 2012, excel 2012 calendar leave planner, staff holiday leave planner excel, leave planner excel 2012, employee leave planner excel, staff leave planner excel free download, staff leave planner 2018, free annual leave planner excel template, annual leave planner excel free download

About the Employer:
( 2 reviews ) Dubai, United Arab Emirates

Project ID: #28878710

Awarded to:

(94 Reviews)
6.6

31 freelancers are bidding on average $21/hour for this job

(811 Reviews)
8.8
(311 Reviews)
7.8
(416 Reviews)
7.4
(240 Reviews)
7.3
(223 Reviews)
6.5
(91 Reviews)
6.4
akritisood94

Hi Nelson I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.

$20 USD / hour
(163 Reviews)
6.4
(81 Reviews)
6.6
zu02

Hi yes I can do this! . [login to view URL] do you need? [login to view URL] - if you can use Ms Access , I can recode via ms Access 3. you can look at "Access Attendance" in my portfolio https://www.freelancer.com/u/zu02, something More

$25 USD / hour
(24 Reviews)
5.5
BAVarun

Excel Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - • Macros • Formulae • VBA • User forms Willing to share a s More

$50 USD / hour
(48 Reviews)
5.1
(14 Reviews)
4.9
(37 Reviews)
4.6
(6 Reviews)
3.9
realtechsl

Hi there, I have read the project description and i think i am the right person for this job. I can complete this work in prescribed time. Below are my MS-Excel expertise: Data formatting Data Analysis Data Validatio More

$20 USD / hour
(9 Reviews)
3.6
AnuradhaVM

Hi, Greetings! ✅checked your project details. I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data entry, Data analysis and MIS Management. I have strong analysis, and Excel skills and am able More

$20 USD / hour
(8 Reviews)
3.1
Imran85HR

Hi, Thanks for reviewing my proposal. I have read your requirements for creating a leave planner, I have gone through the excel file and it's quite workable. I am an experienced HR Professional with over 14 years o More

$25 USD / hour
(1 Review)
2.1
jesscol

I am an accountant with more than 10 years working with excel formulas I am happy to help you Kind Regards

$15 USD / hour
(0 Reviews)
0.0
WEEXCELEXPERTS

Hi, we have vast experience in working with formulas and macros. We have created many daily planners, trackers, and holiday calendars. It would be a great pleasure if you give a try to us.

$20 USD / hour
(0 Reviews)
0.0
cathrine110308

Hello, I'm Cathrine. I am a fast typer and good at using the excel. The work present not only accurately also efficiently. Hope you can give me an opportunity to help your work. Thank you very much! Best wishes, More

$20 USD / hour
(0 Reviews)
0.0
Jigneshmerja

I am software engineer by profession. I am very keen to start such freelancer work. I am having very dedp knowledge on ms office.

$17 USD / hour
(0 Reviews)
0.0