Get instant live expert help on I need help with excel month function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I'm trying to get a similar function to work on my excel. =ARRAY_CONSTRAIN(ARRAYFORMULA(index('Contract Month Detail'!$E:$E,match(C6,'Contract Month Detail'!$N:$N,0))), 1, 1)
Solved by S. L. in 28 mins
In cell C11, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions within the excel DATE function. Add 1 to the month result. Copy the function to the range C13:C34.
Solved by D. D. in 18 mins
One month ago, I set up the function "mvemp" in my Excel 2010 file and worked fine. Today when I re-open this file and found "MVEMP" does not work and showed "#NAME?" Why?
Solved by D. U. in 23 mins
Can you help me to create a function that will get the month on the partcular date?
Solved by C. U. in 21 mins
I have a budget excel sheet that linked to an exported cost sheet. I have subcategories within the budget sheet, however every month I update the cost sheet, there are new subcategories. Can I write a function that automatically updates the new subcategory listings into new rows when I export the cost sheet every month?
Solved by O. H. in 11 mins