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'm trying to visualize my date ranges in a calendar format
Solved by Z. J. in 16 mins
Is there any way to have a column of values auto populate into a calendar created in excel based on a start and end date range in two other columns on the same spreadsheet?
Solved by K. L. in 14 mins
i need a formula to return text based on whether a date range is greater or less than 2 years of a v look up range
Solved by Z. B. in 24 mins
Hi, I'm trying to find out the number of specific operations (Criteria in column) we'll have within a specific date range (criteria in row). To my knowledge, some form of sum or sumif is required along index and match. Any help would be appreciated. In the file attached, I am trying to find out how many Operational days we'll have in FY2018 (cell Q12), within the date range (N12:O12), for a specific operation type (P12).
Solved by A. A. in 21 mins
check if a payment is weekly or monthly, then check dates, if payment is due on, within 1 week before week ending then add value. if not then add nothing. =IF(B34=$B$10,E34,IF(AND(B34=$B$11,C34>=$F$12-7),E34,AND(C34>$F$12<$G$12,""))) B34 is stating whether weekly or monthy, B10 & 11is the check, e34 is the value. C34 F12 & G12 are date ranges =if(weekly=weekly,$,if(and(monthly=monthly,due date>=1st week ending - 7 days,$,and(due date>1st week ending<2nd week ending,'"" I'm getting "Value" instead of "" or $
Solved by D. E. in 13 mins
i need formula to check my date from date range in data and give me results for the discounts applied for articles on that date
Solved by B. S. in 17 mins
Please create a pivot table to give a count of lead source grouped between the following date ranges: 13/12/2017 to 15/12/2017 16/12/2017 to 24/01/2017 25/01/2018 to 21/02/2018 22/02/2018 to 22/03/2018 I will then need to see a month on month %variance, if you could show this using icon based conditional formatting that would be great. Thanks
Solved by E. J. in 13 mins
I am trying to count the customized days between specific dates based on a drop down on a spreadsheet. The customized days include building closures. An example is I have a program starting in September. I need to know the week of September it begins (September 10, 2018) and the day of the week it is on (Mondays). The program ends in December (December 17, 2018). Our business has a total of 11 working Mondays in that time frame, but I want excel to calculate that for me. This would have to work no matter what the date range. Can you help?
Solved by S. H. in 11 mins
Every time I add the quotes to this formula it stops working? SUMIF(C7:BB7,"<=BC6",C10:BB10). I am trying to add some numbers based on a date range.
Solved by C. E. in 17 mins
Greetings! I am trying to take a master calendar of touring musicians and produce an itinerary sheet by selecting artist and date range - is this possible?
Solved by V. Q. in 15 mins