Get instant live Excel expert help to learn how to use Excel date series function?

I'm trying to visualize my date ranges in a calendar format

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?

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

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).

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 $

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

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

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?

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.

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?