Get instant live expert help on I need help with excel month name
“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
I need a formula to change the month number in cells E2:E38342 into the month name, instead of just the month number
Solved by V. U. in 28 mins
Hi, I have two excel files which are linked to each other. The first excel file retrieves data from the second excel file.
The name of the second excel file changes every month (FY 2018\06-2018 to FY2018\07-2018. In the first excel file I have a formule which gives me the correct month already. Now I need to manually change the link in the first excel file to the correct month (not a problem when it's one sheet, but we have like a 100 sheets)
Solved by Z. Y. in 27 mins
I want to be able to automatically populate a value field (month) for a project name by finding the invoice value for that month amongst a list of invoices.
Solved by I. F. in 30 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
So I have monthly data - I would like to build a pivot table that combines each account name and show if the data change from month to month in a pivot view table look
Compare field needed and highlighted if the data changed from month to month
Stage change
Booked upsell change
Close date change
Solved by B. A. in 12 mins