Attached is the basis of a leave spreadsheet that staff can select a leave option and the system will convert it to a number of hours.
I'm trying to work out how to add the dates to specific years... ie if my leave anniversary is june 1st if I book leave before May 1st then it will come from 2016, if leave is booked for june 2 then it comes from 2017 leave allowance... I can get it to work on whole months but not specific days
Please can someone help to make the attached spreadsheet work?
No file attached.Originally Posted by marktc19
To attach a file to your post...
Click the Reply button to open the Reply Editor
Click the Go Advanced button
Scroll down until you see the Manage Attachments link and click that
Click the Browse button and select your file
Click the Open button
Click the Upload button
Click the Close Window button
Click the Submit Reply button
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks