How do I set up a vacation report using hours alloted based on hir

E

EW

Hello,
I've been trying to create a vacation report based on hire date to determine
the yearly allotment of hours. No luck so far.

Any help would be greatly appreciated.

Earl
 
T

Tom Ogilvy

As a start and with no details,
Look at the datedif function
http://www.cpearson.com/excel/datedif.htm

Only documented in help for xl2000, but available in all versions.

Once you figure out how many months, days, or years, then possibly use
Choose or some multiplier or use a vlookup table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Mulitple If Statments 3
How do I set up a plan for my allotment? 1
Break on Calendar Year 4
Vacation accrual based on years with rollover 1
Calculate leave time in a query 4
Case Select - Vacation Accruals 3
Figuring Vacation Hrs. Earned using Current Date minus Hire Date 6

Top