Get instant live Excel expert help to learn how to use Excel date series 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 am trying to brainstorm on how to get a formula to look up a contract, if it is between a certain date range return the value for the % associated with it. I have 2 tabs that it would be using in a spreadsheet, then it would need to multiply the MPDQ on spreadsheet 1 x the %x a fixed amt 1.084 to give the desired result. I am not sure if I need to say it is November 1 and put in the formula that if it falls between this date range vlookup contract and return this value, or would it be easier to match index and do the calculation?
Solved by I. U. in 25 mins
I have VBA file which extracts the historical prices (old prices) from yahoo website , however at a time, it can only extract it for a single share (when you enter the name of share manually). I want to make changes so that we will be able to extract details for a multiple shares and corresponding to that their closing prices for the selected range. I will enter the list stock names in the Column A and enter the date range manually (start and end date), then it extracts the data from yahoo. It's working file, however I want output to shown in a different format.
Solved by D. S. in 27 mins
I can generate the attached file consistently. I can repeat it with the same columns and data. My goal is to create a macro that takes this sheet and creates a new file with the same data show Month to date and Pace. The date range in this spread sheet is Dec 1-8 or 8 days of 30 selling days in December Finally... I really need to make it more pretty... or call out the TOP Activations, ACCESSORY and TOTAL REVENUE store
Solved by I. W. in 15 mins
help in a complicated formula picking a value from date excel range
Solved by O. U. in 23 mins
Question on a SUMIF formula: =SUMIF((H6:H494),">01/01/2017"and"<10/31/17,I6:I494) is not working for me. Trying to use sumif date range for all sales numbers within a date range of one month. Thank you
Solved by G. D. in 14 mins
Needing help expressing a date based on date range Excel If Date = 01 OCT 2017 - 30 APR 2018 + 380 DAYS Excel If Date = 01 MAY 2018 - 31 JUL 2018 + 270 DAYS Excel If Date = 01 AUG 2018 - 30 SEP 2018 + 430 DAYS
Solved by E. J. in 19 mins
In the Date Range column, for date ranges that are -08-01-2015-12-31-2078, I want the 12-31-2078 deleted. Ideally, I would like to keep in the same cell that is currently being used.
Solved by S. W. in 30 mins
I have a start and end date. In the next column it shows "% thru" i.e. how far into the date range we've gone. I want to make it so that the %thru never goes past 100%.
Solved by C. J. in 14 mins
I'm using an array function to calculate the number of overlapping days in a vertical set of date ranges, but i want to separate the counting of overlapping days based on a value in column A of each row (i.e., still compare the date in a row to all of the other dates in the spreadsheet to see if there is overlap, but total the overlap in two sets based on the two possible values in column A). Alternatively, i could use an array function that gives overlap values by row and then use a sumif function, but only if i can figure out how to not double count overlapped days.
Solved by K. Q. in 30 mins
I have a table that lists data by date and time (in separate columns) I am able trying to extract the data using countifs date range to auto populate other tables containing overviews by week and month. I can get the data via date easily, however I now need to count data between two times (06:00 - 18:00) on a specific date or date range.
Solved by F. H. in 12 mins