I found this useful for past dates, but now I need to know how to find the closest date to today, when you have a bunch of dates in the past and future? Let's say you have a list of events but only need to know the one that's a week away from now.
Do you have any idea why the min and max functions are not working for me. I have a list of 2000 dates in the month of December. All I want to do is return the earliest and the latest dates from the range. I try using =min(g18:g2000) and =max(g18:g2000). For both these functions I just get back 1/0/00. If I convert it to a number it is just zero. Why doesn't it return the minimum and maximum dates?
Hi sir. Can you help me? What i wanted in my ghant chart is that when i add a holiday, all activities will adjust even if the other activities did not fall onto the holiday date.. can it be possible?? Love the video by the way.
I have a dataset for a car rental company and I am trying to find the number of months that each vehicle has been in service. I want to find the min month to see it's first month in service and the max month to find the last month it was in service and then find the total number of months based upon those two columns. I can't for the life of me figure out how to get just the month to show up instead of an entire date. I just want 1,2,3 etc for min and 10,9,8 etc for max. Would you have any suggestions?
Thank you! I have been trying to work this out. This just made a complex report where I have to strip out duplicates much easier!
Thank you for covering the part of using Table and Column names to attempt to future proof the formula .
Loved it. Thank you for making the time to be clear and such a simple way of getting what i needed without overcomplicating it! I appreciate you.
Chester, thank you. I been searching some solution with help of this function, which perfectly explained in your video. Thank you. Alexander K.
Another great tutorial. Thank you Chester!
Thank you. Very clear to understand.
Great lesson Chester! Thanks and thumbs up!!
Great 👍. U can use whole criteria rather than selecting one criteria and drag . It will give spill range...
Thank you, it was very helpfull
Thanks. Solved my problem
My criteria in the date! I have a list of dates and I want to find the minimum date that is after a given date (which is stored in a different cell
I found this useful for past dates, but now I need to know how to find the closest date to today, when you have a bunch of dates in the past and future? Let's say you have a list of events but only need to know the one that's a week away from now.
Do you have any idea why the min and max functions are not working for me. I have a list of 2000 dates in the month of December. All I want to do is return the earliest and the latest dates from the range. I try using =min(g18:g2000) and =max(g18:g2000). For both these functions I just get back 1/0/00. If I convert it to a number it is just zero. Why doesn't it return the minimum and maximum dates?
Hi sir. Can you help me? What i wanted in my ghant chart is that when i add a holiday, all activities will adjust even if the other activities did not fall onto the holiday date.. can it be possible?? Love the video by the way.
I actually need the opposite of this. Return top three items of most recent date. Can you refer me to a relavant vid?
I have a dataset for a car rental company and I am trying to find the number of months that each vehicle has been in service. I want to find the min month to see it's first month in service and the max month to find the last month it was in service and then find the total number of months based upon those two columns. I can't for the life of me figure out how to get just the month to show up instead of an entire date. I just want 1,2,3 etc for min and 10,9,8 etc for max. Would you have any suggestions?