Hello
I am intermediate Excel user for years and just found your site again. Heading says I have been a member for 1729 days and have not posted yet. I found old user and password.
Hope you can help with current formula and page setup problems.
Hello
I am intermediate Excel user for years and just found your site again. Heading says I have been a member for 1729 days and have not posted yet. I found old user and password.
Hope you can help with current formula and page setup problems.
Vacation tracker had no formulas. Formulas that I already implemented:
=YEAR(TODAY())-YEAR(A3) shows number of years worked based on start date
=EDATE(B4,-12) shows anniversary date during last calendar year
=EDATE(A3,B3*12) shows anniversary date for this year (midyear)
=EDATE(B4,12) shows anniversary date during next calendar year
=VLOOKUP($B$3,$A$37:$C$86,3,0)+SUM($F3:$Q3) shows number of hrs from chart based on yrs worked minus used hours used during all 2017.
7 start dates: 1-14-99, 5-31-11, 6-10-81, 7-13-99, 7-30-02, 8-3-83, 8-27-80
Problem is way this one page spreadsheet was setup. Each of 7 Supervisors has top row w/ months 2017. Next row used to input hrs used as negative numbers. With only two rows and used hrs input on monthly basis, is it possible to formulate hrs used during anniv month as part of previous yr just ending or next yr just beginning.
Creating 5 yr on same sheet continuing to the right (eliminating need for carrying over to other tab years). I am trying to not have 365 columns for every day, however I might have to revamp and if so will put years on different tabs. Also, need formula to minus out used expired hours and input hours for new yr.
Thanks
Hello wanna_B,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks