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!”
Here are some problems that our users have asked and received explanations on
I have a tire storage spreadsheet for a shop. I want to set it up so that when I change the date that the tires were stored, I can then get the entire row to change text colour. But the date ranges vary depending on the season
Solved by B. B. in 16 mins
I have a table covering data from one year to the next. Each row has different dates, sorted oldest to newest. I want to show the date ranges as data is added above the table headers. e.g. 'From 1 Jan 2015 to 31 Dec 2017. If I add some more data in Jan 2018, I would like date range to change to reflecy=t that. e.g. 1 Jan 2015 to 23 Jan 2018
Solved by D. J. in 29 mins
Looking for solution -
look at date tab - Look at name on summary tab column B - count how many New and Existing (column C- data tab) fall in specific date range Row 3 (summary tab) and count how many are within that 15% range per name in that given month
Solved by S. D. in 20 mins
I am having trouble with a median calculation using nested ifs. This time it's for a text status within date range.
Solved by Z. J. in 26 mins
i am having trouble with a median calculation with nested if criteria.
i need to find the median sales price within a date range.
last time i tried excelchat was having technical issues with downloading so trying again.
Solved by B. B. in 25 mins
I Am using a Sumifs formula , so i have created for date range with 2,3 cell, but when i am adding new name the formula have to copy and special paste (value), now i want to auto update the cell value with formula cell refernce.
formula is =Sumifs('A'!B:B,'A'!A:A,">="&B3,'A'!A:A,"<="&C3)
SUMIFS(CELL NAME RANGE,CELL VALUE,CELL NAME RANGE DATE RANGE)
Solved by G. L. in 21 mins
Anyone able to help with something I'm struggling with on an Excel spreadsheet please? I'm trying to work out how to create a formula for the following;
Monthly sales value for a particular sales category between a specific date range (in month), I've searched online and can't find anything to help.
Solved by B. H. in 12 mins
Hi there, please help with excel date time functions
Solved by X. J. in 23 mins
I want to insert excel current month, help please
Solved by M. Y. in 20 mins
How can I insert excel current year?
Solved by A. Q. in 19 mins