Get instant live expert help on I need help with excel date range

“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 am trying to find a formula that determines if date range A lies within date range B, then return how what days are in the range, followed by the start and end date. Example: - Date Range A = April 1 - April 30 - Date Range B = April 15 - Dec 31 Answer I need: - the start date of the range overlap is April 15 (Cell 2) - the end date of the range overlap is April 30 (Cell 3) - Number of days overlapping is 15. (Cell 1)
Solved by F. W. in 22 mins
hello i have the range of dates and the range of serial numbers respective to the date. I want to find what is the last recorded date of repeated serial number from date range.
Solved by C. Y. in 18 mins
I get the error - Incorrect argument set with this formula... can you see what is wrong? =IF(WEEKNUMBER(TODAY()) = 1, COUNTIFS({Created Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = 52, {Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1), COUNTIFS({Created Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), {!FVE eHRT Resource Center Tickets Range 2}, ="SNF")
Solved by V. W. in 17 mins
i need help with sumifs for a date range
Solved by D. D. in 26 mins
I need a formula for excel that counts the number of rows that have a created date range for each month of the year
Solved by C. H. in 11 mins