Get instant live expert help on I need help with start of month excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Trying to calculate date of eligibility (DOE) and corresponding code based on several inputs
Date of Hire(DOH), Plan Start Date, Date of Termination (DOT) -if entered and whether or not the DOE should start mid month or at the start of the next month.
Solved by T. C. in 16 mins
Calendar Reference, How to lock an event to start on a specified date, regardless of month.
Solved by A. A. in 13 mins
I am working on a formula to calculate pay. However I want to ensure it accurately takes into consideration start date and number of days before the end of the period (month). I currently have a formula in there and it is doing the calculate based on weeks (assumption they start at the beginning of the month), however, if someone starts in the middle of the month, I need it to calculate the hire date through the end of the month. I have the cells i'm working on highlighted in red.
Solved by X. W. in 23 mins
I am trying to get a formula for working out a series of cash flows based on input start date and fixed distribution of spending over 14months.
The solution provided by a Gotit Pro last week, works well, but there is some sort of error in it, for the last month. No matter when the start date is, the last month of 6.25% of spending does not show up.
Solved by A. F. in 23 mins
Hi, I want to adapt the formulas to consider employer start dates within a month
Solved by E. H. in 30 mins