“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello! I need help with a formula for adding two date ranges. Basically, I am trying to calculate total length in service for my job - but I left for a few months, so do not want those calculated. I want to calculate November 11, 2014 - August 2, 2017 PLUS May 21, 2018 to [today]. Can you help?

Solved by M. Q. in 28 mins

I need the formula for column Q in this spreadsheet to 1) populate values of columns S and U should the dates listed in columns T and V fall within the specified date range in the formula in column Q - this could happen for either column, or have the two values summed if both meet the criteria. as the formula is right now, column Q is zeroing out if one of the dates is outside the criteria.

Solved by G. Y. in 16 mins

SUMIFS(D6:D446,"*PLUK teacher income*",E6:E446 ,A6:A445,">=" &O2,A6:A445,"<=" &O3)
I have a formula: SUMIF(D6:D446,"*PLUK teacher income*",E6:E446)
I want to add te range between specific dates.
I have this formula currently: SUMIFS(D6:D446,"*PLUK teacher income*",E6:E446 ,A6:A445,">=" &O2,A6:A445,"<=" &O3)
A = date range
O2 is date beginning
O3 is date ending
What am i missing!

Solved by V. J. in 28 mins

I need a formula to pull data from a group of cells that are date sensitive from sheet 1 to total them on sheet 2. A date range example- (june 6 to June 30) is on sheet 2 , this range will be used to select the dated cells with the same dates from sheet 1.

Solved by E. H. in 15 mins

I would like to use a formula in Excel to add up data that meets two criteria - being in within a certain date range and meeting one criteria. This would be easy enough, but I would like this to add up data over different sheets.
Cell C3 on Sheet10 explains what I am trying to do. Thanks.

Solved by T. J. in 20 mins

I have a tab in google sheets that shows performance by day. I want to quickly see a sum of data of any custom date range. As of now I have the table to the right of the daily metrics but I might want to break it out into a new tab. This is just for the DNA Performance by Day tab.

Solved by E. Q. in 12 mins

I have a tab in google sheets that shows performance by day. I want to quickly see a sum of data of any custom date range. To the right of the data I want to show a summary of any date range. This is just for the DNA Performance by Day tab.

Solved by A. F. in 11 mins

I'm designing a spreadsheet to track the daily status of over 40 personnel. I'd like to simplify the process by having the "calendar" portion of the spreadsheet have its cells populate with color based on the date range I enter at a section at the bottom. Is this possible? Currently I have to manually highlight the date range and select the appropriate color scheme.

Solved by T. W. in 15 mins

I have a large set of files (two folders with 104 and 156 .txt files each) The text files are tables of 4 columns by some 11000 or 16000 rows. The files are named so that columns 2 and 3 are obsolete if the 4th row's data can be tied to the filename by having the latter imported as a header. The 1st column is a date range that does not vary between any of the 260 files. Can I (somehow) import the 4th column of these txt files in a timely fashion to a singe worksheet with each column showing the file name followed by the 16000 rows of data?

Solved by F. H. in 21 mins

I need a formula that counts the number of lines from another sheet, within a date range and removing the duplicates. So we have 3 different lines for 4/7, 4/7 and 5/7,the formula should calculate 2 as there is only 2 different days in the data with the range 1/7 to 7/7

Solved by K. L. in 21 mins