Excel IF Function Date Between Two Dates #2 (+1 Expert Bonus 👔)
#excel #if
📰 Excel IF Function #2 to calculate if a date is between two dates.
How to set a condition with the Excel IF formula when a date falls between two other dates or two other values. What is the formula to express a date range? The IF function is limited to one condition, so how to add the test for the other date? What logical operator to use to determine if a date is included in another? Is the Excel IF formula sufficient? The next video will discuss the IF function with multiple conditions.
I answer these questions in this simple and accessible free Excel tutorial video.
I show you how to use the IF function and the AND function in a simple case study.
Case Study:
//////////////
How to identify employees who joined in January based on their date of entry into the company?
Find the solution to this problem in this video.
And I also reveal an expert bonus to count the number of employees who arrived in January. Simple, effective.
Tell me in the comments how this Excel video has helped you?
⌚ VIDEO PROGRESSION
▬▬▬▬▬▬▬▬▬▬
00:00: Introduction
00:38: Explained Case Study
01:39: Expert Excel Bonus
02:40: IF Function #3
🎥 SERIES VIDEOS:
▬▬▬▬▬▬▬▬▬▬
1️⃣ Simple Example of an IF Function: • Excel fonction SI : exemple simple pour dé...
Follow me on social media:
▬▬▬▬▬▬▬▬▬▬
🎥 To subscribe on YouTube: https://bit.ly/TD_YtAbonnement
➡️ Facebook Help Group: https://bit.ly/TD_Entraide
😎 Who am I?
▬▬▬▬▬▬▬▬▬▬
I'm a Toulouse native who loves education, with 15 years of professional experience as a computer engineer.
A husband and father of 2 children in Toulouse. Between diaper changes, I prepare my videos!
I help Excel users become PROs.
This video is for those who use Microsoft Excel and are looking for Excel Office 365 training. Specifically, a search for Excel IF date between two dates, Excel IF combined with the Excel AND function, and date range.