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?