Microsoft Office Standard for PC Logo
Posted on Sep 05, 2007

Creating a holiday accrual spreadsheet.

Hi I need some help with setting up an accrual spreasheet to keep track of staff holidays, can someone help me with the formula? i need the formula to calculate the holiday from the start date of the employee to the current date. Any Ideas? Many Thanks

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 9 Answers
  • Posted on Sep 06, 2007
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

Joined: Jun 12, 2007
Answers
9
Questions
2
Helped
39163
Points
10

Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

656 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19190 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...