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!”
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