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

Hello, I am looking to highlight the cells that have text in them to highlight as red between the 1st through the 15th of every month, and then be green the 16th through last day of the month whether it be the 30th, 31st, or even 28th (depends on the month). I attached a sheet in which I was testing by highlighting all of the cells with text (the 1 of 8, 2 of 4, etc.) then clicking "Conditional Formatting" > "Highlight Cells Rules" > and then either Greater Than or Less Than for both red and green using the following formulas for each month: Less Than (Red): 2017-08-15 2017-09-15 2017-10-15 2017-11-15 2017-12-15 Greater Than (Green): 2017-08-15 2017-09-15 2017-10-15 2017-11-15 2017-12-15 I am not sure what I am doing wrong but when I did the formula and chose the colors for August, it seemed to work fine, being today's date would be within the right date range for the cells to highlight as green. I then removed the August formulas and replaced them with September formulas, it did not seem to work.
Solved by C. W. in 14 mins
How do I filter the "Leads Pivot" Table by a date range using excel on a mac?
Solved by M. H. in 23 mins
How do I filter a Pivot Table by a date range?
Solved by G. Y. in 11 mins
Rate Start Date = 05/01/2011 Rate End Date = 31/05/2017 Declaration Date From = March-17 Declaration Date To = May-17 Volumes = 69 Rate = 0.20p I need a formula that will calculate volumes * Rate, but only if the declaration dates are within the rate start and end date range please
Solved by S. L. in 14 mins
I am trying to build a formula in excel that looks at a certain date range and returns adjacent values based on a criteria
Solved by I. F. in 11 mins
There are two columns, zip code and DOB. I need a chart to show the distribution of zip codes, how many different codes are represented and how many are in each zip code. I also need to show age distribution from the DOB data. All dates with "00" in the year can be ignored. Ideally I need the DOB data to be displayed in date ranges (<18, 18-24, 25-34, 35-44, 45-54, 55-64, 65+).
Solved by G. D. in 15 mins
There are 22,289 records (lines) each with a column for zip code and DOB (date of birth). I need every record (22,289) represented in two separate charts. The first chart showing the distribution of zip codes, how many zip codes are represented and how many time each zip code is represented, and records without zip codes can be listed as "none" The second chart should use the DOB column and show a total record count for birthdays within the date ranges as listed below <18, 18-24, 25-34, 35-44, 45-54, 55-64, 65+. Dates with "1900" for the year should be listed as "n/a" and not counted in the 65+ age range.
Solved by A. F. in 11 mins
Hi, first time forum user, so trust I will make this make sense. :-) I would like to find all suppliers in a table named x for a certain date range, ie month and display total $ value for all found. Table contains 4 columns, Suppliers name, Invoice No., Invoice Date and Invoice total.... There are several invoices for each supplier all with a different dates and value. Thank You!
Solved by G. L. in 18 mins
Hello, I'm trying to find a formula that identifies a date from a number (representing day of month) so that it triggers whether or not a payment is to be made from the date range (week) in question. This is to form part of a weekly cash flow forecast. Thank you
Solved by C. Y. in 25 mins
I am trying to use a spreadsheet to calculate values for my ESCOs. We have one spreadsheet on Tab Manual TSA Calc, Cell O8 has an example of what I am trying to do. I need to look up by Contract listed in O5:AA5 on Tab Req (requirements) to locate the percentage by date range. So for example if the month is november and it falls with in the date range of the contract we need it to look up the correct % to x col AH (mpdq)x1.0184 to return the correct capacity for our marketers. Any help on brainstorming this would be appreciated. Thanks, Jenn
Solved by K. D. in 20 mins