Dear Colleagues,
I would need your help to complete my file. I am prepare budget salary base on actual joining date and budgeted joining date. I can only manage to get the formula by joining month not by joining date.
Attached is the sample file
Dear Colleagues,
I would need your help to complete my file. I am prepare budget salary base on actual joining date and budgeted joining date. I can only manage to get the formula by joining month not by joining date.
Attached is the sample file
Any one can help me on this?
Are you talking about this formula?
Formula:Please Login or Register to view this content.
Can you explain a little more what are you trying to archieve? Also what is the expected result of your example and why?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
put the date in N4 - Y4 and format as MMM.
use:in N8 - Y32Please Login or Register to view this content.
Ben Van Johnson
Dear Fotis & Leah,
Thank you for your help.
My requirement is, for the first joining month he/she should get the salary from joining date not full month salary and from following month will be full salary.
How about:
Please Login or Register to view this content.
thank you so much Leah, It's worked! But Could you correct for me total salary amount are swept in first & second person.
And when counting the working day we add one extra day eg. staff joined in 6 Jan 14 . formula will be 31-6+1 = 26 working days
According to your attached sample file, who joined in 6 Aug 14 Total Salary should get in Aug 5,452/- and joined in 6 Jan 14 should get 4,192.
Thank you for your help
Last edited by Thet4444; 02-12-2014 at 11:10 PM. Reason: need more
Please Login or Register to view this content.
Dear Leah,
Thank you for your help, formula is almost there, but salary of A & B staffs are sweeping
eg - Staff A Total salary is 6500/- but formula calculated with next staff salary 5000 and for Staff B it take 6,500/- instead of 5,000.
Please help me......
Please Login or Register to view this content.
Hi Leah,
Thank you for your help and time, It's work perfect..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks