# 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 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)
Solved by I. H. in 19 mins
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
Solved by G. D. in 26 mins
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
Solved by X. H. in 14 mins
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)
Solved by F. E. in 16 mins
Hi, I AM MUKESH I WANT TO CREATE ACOUNTIF FORMULA WITH DATE RANGE ACROSS WORK SHEET WITH REFERENCE .
Solved by E. U. in 21 mins
Hi, I AM MUKESH I WANT TO CREATE ACOUNTIF FORMULA WITH DATE RANGE ACROSS WORK SHEET WITH REFERENC
Solved by I. U. in 14 mins
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?
Solved by V. U. in 27 mins
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.
Solved by I. J. in 17 mins
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
Solved by B. E. in 17 mins
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
Solved by S. C. in 19 mins