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

I need a formula to track time against projects within a date range. Sum Hours (Timesheet!G:G) based on "Activity" (Timesheet!C:C to match against Reporting!B14); within date range (Reporting!>B49 & <C49)

I am trying to use a forumla to group information by user and date range: =COUNTIFS('LTC SSRS Data'!$A$2:$A$8000,">6/30/2018",'LTC SSRS Data'!$D$2:$D$8000,'Inbound Report'!$A9) I am trying to chage the ">date" with a >than cell which has the date.... This formula works =COUNTIFS('LTC SSRS Data'!$A$2:$A$8000,J11) but when I change the "j11" to >j11 it will not work

I dont have a programming background so I was looking for the most simple solution to the following problem. I want to determine whether a month (i.e. July) falls between two date ranges (1-7-2018 and 1-9-2018). Is this something that can be done?? Just for those more visually inclined: D E M N O 4. July 488. 123,456 491. 1-7-2018 1-9-2018 500. 123,456

I am trying to return a dollar value if the date it was generated is between a date range using sumifs. The formula is returning zero and I cant work out what I have done wrong. =SUMIFS(I$14,M13,"=>"&J$14,M13,"=<"&K$14)

Hi, I AM MUKESH I WANT TO CREATE ACOUNTIF FORMULA WITH DATE RANGE ACROSS WORK SHEET WITH REFERENCE .

Hi, I AM MUKESH I WANT TO CREATE ACOUNTIF FORMULA WITH DATE RANGE ACROSS WORK SHEET WITH REFERENC

I have an excel calendar of events. The list of events has a mini monthly calendar to the left of it with a formula in each date which reads =IF(D13="","",IF(MONTH(D13+1)<>MONTH(D13),"",D13+1)) When entering in an event date to the right of the mini calendar it highlights the date on excel calendar. How do I expand this to a date range instead of a static date?

i need a formula that will give me the price at the time of purchase for a customer. sheet 1 has columns: date purchased, item, price paid sheet 2 has columns: item, price start date, price end date, price. Prices on sheet 2 change according to the date range they are in. need to pull in the correct price from sheet 2 onto sheet 1 based on the purchased date.

How do you show inventory on chart with a date range? All it wants to do is show by bar. Need something like a stock chart with timeline. How do you do it

I am working on a formula that will give me a 2 week date range for 1st to 15th or 16th to end of month. I found this that will do a year but as mentioned i only need two weeks. =DATE(B1,E1,1)-(WEEKDAY(DATE(B1,E1,1),1)-(H1-1))-IF((WEEKDAY(DATE(B1,E1,1),1)-(H1-1))<=0,7,0)+1