Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M., Computer Support Specialist

Category: Microsoft Office

Satisfied Customers: 5964

Experience: Computer Software Specialist for more than 10 years

49766785

Type Your Microsoft Office Question Here...

Jess M. is online now

I have an excel 2016 question. I have a spreadsheet with

Customer Question

I have an excel 2016 question. I have a spreadsheet with contract date ranges, e.g. 04/01/2015 to 03/31/2016, 08/01/2016 to 7/31/2016. I need an excel formula to evaluate the beginning and ending dates and calculate how many months have occurred in a certain year, as of a certain date. For example, if the as of date is 09/30/16, then the answer to first date range is 3 months for 2016, and the answer to second date range is 2 months for 2016.

Hi Tim, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Can you please send me a sample of your Excel file so that I can directly work in the needed formula? Just save a copy of the file, then delete sensitive info, then use the Add Files button to attach it when you reply.

Please let me know by replying to me here so that I can help you further.

I got the file and it appears to be straightforward. Now my question is, do you want it to be dynamic by using the TODAY function in column D? That is, when you check or open it by December, it will be calculating FOR December.

Ok. In your sample file, let is look at the first row, and that is cell D4. What is the correct computation? Is it 12 months? That is, the end date is 9/30/2015 and it has been 12 months up to this current date. Please confirm if 12 months is correct.