I have a spreadsheet that measures productivity (sales/hours). When extra tasks are accounted for by inputting extra hours for those tasks, I need the cost of those extra hours to be spread accross future months (excluding the current month and next month). To do this, I used this formula: =C9-(IF((COLUMN(C29)-2)>=MONTH(NOW())+2,SUM($C$23:$N$23)/(12-MONTH(NOW())),0))
The formula works, but does not achieve its desired purpose because when the month changes, the cost of the extra hours becoems excluded from the current month and next month and spread only accross future months. The cost that was spread to the prior month and following month need to remain. Perthaps it is possible to make the cells in row J lock on 8th of every month prior? Or for amount absorbed in row 7 for each month to be removed from the sum spread accross future months?
However this formulais fixed, I want to avoid the use of macros or command buttons.
Hi, Greetings!
✅checked your project details: Improve or replace excel formula
✅Completed Time: In project deadline
We have worked on 650 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Digital screencast
Hi,"I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.
Hello sir, I can Improve or replace excel formula to acheived desired outcome by maintaining 100% accuracy of your data absolutely as you want. -------VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting.
I can start right now, please message me to discuss more.
Regards,
MA Hossain
That is a pretty simple job as per my standards. I can perfectly create such a dynamic formula for you. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Dear,
I read your description carefully and I am filled with confidence that I can complete your project wonderfully.
In the past, I completed many excel projects.
I have rich experience in excel visual basic Matlab.
I can complete your project with the best quality in time.
I hope your kind contact.
Best Regards.
Hello client,
I am accept your opportunity my experience and knowledge to your project is very helpful and completely work at your require time.
I am expert of Excel work at last 3 years so kindly contact me your project is very accurately completed at a time.
Thank you