Write an IF Statement for Dates Between Two Dates (Date Range)

Thanks so much!

Great video. BUt I can't find a way to get a calculation to run at a given time of day. For example I have live data which is ever changing via web connected table. I want to sum the vales of one column at say 10:PM. How would I be able to do this. This would be a web table without any correspondingtime values. I just want to calculate values as a snap shot in time. I would have a new table with a set of time vales and would want to create a snapshot sum against each time value. e.g I would have time values 10pm 10:05 pm, 10:10pm ... etc and create a sum value for each. So the corresponding cell would be blank until calculated. For exaple I a monitoring the Dax via a web connection and want to do a straight sum of % change in price of all the companies in the table as a sequence of snapshots in time every five minutes of the trading day and store them in a table. can you think of a way to do this?

This was super helpful! Thank you for putting this together.

Thank you , 3 mins in and i ave my answer. I can go have a cup of tea now with the time I saved.

🙋‍♂️ question. How can I create a date series that covers just certain days of the week. I need a date series that covers mondays tuesdays and Thursdays.

How can we do the same thing in vba?

What if you have multiple dates.

THANK YOU!

How can I find a date range, between another date range? Lets say Colum A1: 11/02/2022 Column B2 11/30/2022, and then I have a list of initial and ending dates in separate columns, where I need to know an specific value for the dates in A and B Columns?

Please list 2-3 dates and time ranges that you could do an interview.

Thank you Sir, nice teaching.

Hi There how would I return a Expired in a cell, I have got a Manufactured date and a Expired date ?

Thank you very, very much!! In 5 min. Its all clear.

it helps me a lot!! thanks!

What if you have 3 columns all have dates, then you want the 3rd column to highlight if it is between column 1 and 2. YOu have 100's of dates. How do you get the between to go all the way down?

Is there a way of displaying a cell with a color IF the date is within a few days to a given date? Lets say I have a due date of some day. If todays date is within a few days before its date I want it to display a color denoting its coming time to get the job done.

what if you have a bunch of date ranges listed under columns A and B and a bunch of separate dates listed under column C, and you wanted the date range cells to highlight if any of the dates listed in C were within them?

❤️

How to find the date from the specifics list that falls between two given dates

What if you wanted to do this with multiple date ranges?
In this video, you used dates between the 9th and 13th to return a value (true/false).
How would you do it if you wanted to see if the date fell between the dates and if so, return a value?
For example, 9th-13th (James), or the 14th-20th (Jenna), or the 21st-30th (Robert)
Would you have to stack all of the different functions within the same cell?

THANK YOU.
Exactly what I was looking for

How to find the exact dates which overlap?

thank you

Can I use this for multiplite dates?
For example: F and G 09.03.20 and 13.03.20 also 25.03.20 - 30.03.20. I want that it will highlight only dates between this two dates. Other ones will be not. Is there a solution to this?

what if you have multiple start and end dates?

Easy peasy -- thanks!

This is what exactly i need . All the best wishes to you !

Solved my problem! Thanks

Awesome. This lesson resolved my query. Thank you!

Thanks, Chester. I am Your number 1 fan, nothing I was trying was working, I was getting sooooo frustrated.

Thanks Bro! More informative content!

Thats a good think, just keep it up

PL REFER ANY FORMULA FOR - IF MONTH IS <= TODAY ()THEN THE VALUE= 'A CELL" OTHERWISE SOME OTHER. I AM UNABLE TO SORT THIS PROBLEM.

Thank you for the video, I have tow dates, From Date and To Date and I want to fill in the cell if he is on vacation or on Duty. How to do this. I use function TODAY() and still not working properly. Plz advise.

Helpful. ..Deserve more video.

Can we do the same in time values?

Thank you!

Excellent, I always had a hard time remembering AND with IF condition, u saved my day. thanks

Now, I am sure this can be done, just don't know where I am getting wrong here if any kind soul could assist, will make me a happy person. Thank you
Essentially trying to create a conditional format to cell A2 that allows someone to be able to input only weekdays between the dates below. Thank you
=IF(AND(A2=WEEKDAY(A2,2)<6,A2>=DATE(2021,1,1),A2<DATE(2049,12,31))

Thanks for this!

I subscribed your channel. Please show what are the possible ways that a PDF file can be transfered to EXCEL.

I am looking for a formula that allows me to change data based on time of day.

For example, I want a cell to change to a different link every 15 seconds.
When I type in =IF(now()=time,reference data) it doesn't work.

is there a way to get the NOW() to work in an if statement?

thank you so much your logic helped me a lot

So let me try just asking someone to help me with exactly what I need. I want everything on a row to be red if the date in column B is prior to September 1st. I wanted to be green if it is September 1st or later.
And I should clarify I'm only using column A and B. A is the name B is date. I want column A and B to have the highlighted color. Not C & Beyond
What is the formula I need to use for this?

I setup my page exactly the same with the one exception. Column A is a list of names. Column B lists the dates. Otherwise everything is the same including the headers and the formula. They issue that I'm having is that when I enter the first Formula explained, under "refer to cell", the formula applied but it does not recognize the date in column B. It is not until I re-enter the date that it actually applies. He does not have to do that in this video. I want to apply the formula to a spreadsheet that is already full of dates.

Column A John Doe
Column B 2020/09/13
Column C =AND(B2>=$G$2,B2<=$H$2)
Column d blank
Column e blank
Column F blank
Column G 2020/09/01
Column H 2021/08/31

When I hit enter after the) in column C, the value returned is false. But if I go to column B and manually enter the exact same entry 2020/09/13 the value in column C changes to true

This is not working in excel please help??????????

Wow, your video totally solved my problem. I'd been racking my brain and doing GOOGLE searches, but I wasn't even aware of the datevalue function. Thank you!

Sir, I am facing a problem with retirement dates. If someone took birth before 15th day of a month, I have to choose the last day of previous month as his retirement day and if he took birth after 15th day, I have to choose the last day of the same month as his retirement day. Is there any solution to this problem?
Is there any way to blend =EOMONTH(serial number, -1) and =EOMONTH(serial number, 0) with IF formulas?

Excellent, thank you, thank you so much,