FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
September 1, 2016
 

Greetings from The Excel Addict
Hi fellow Excel Addict,

Thanks for joining me today for my 'Excel in Minutes' tip.

Please feel free to share it with your friends—chances are they will too.

I
f you missed my 'Excel in Seconds' newsletter from Tuesday, I showed how to 'Be Careful When Using Numeric Column Headings'. You can read the tip here.

Keep on
Excelling,
Francis Hayes (The Excel Addict)
Email:  fhayes[AT]TheExcelAddict.com
 

Francis Hayes (TheExcelAddict.com)



If you missed my last newsletter, you can click here to view it online.


 
TheExcelAddict.com Quote of the Day

"Whether you like it or not, YOU are the most
influential book your children will read
on the subject of character."

-- Mark Timm --

If you have a favourite quote, send it to me and I may post it in my newsletter.

Today's Microsoft Excel Tip

Check if a Date Falls Between Two Other Dates

If you need to check if a date in one cell falls between dates in two other cells, here's a formula you can use.

=IF(C2=MEDIAN(A2,B2,C2),"Yes","No")

Check If Date In Range in Microsoft Excel 2007 2010 2013 2016 365
DOWNLOAD THIS PRACTICE FILE

In this example, the date we want to check (our target date) is in cell C2. The MEDIAN function returns the middle value of all values we supply to it. So we supply it with the three values we want to evaluate: our target date plus the two values we want to compare it against.

In this example, since the date in cell C2 falls between the dates in cells A2 and B2, the result of =MEDIAN(A2,B2,C2) is 16-Oct-2016.

Next, the formula uses the IF function to check if the value in C2 (first reference) is equal to 16-Oct-2016 (i.e. the result of the MEDIAN function). Since it is and the result of the IF function is TRUE, the 'value if true' result is Yes.

Alternatively, you could omit the IF function and use this formula to return a TRUE or FALSE result.

=C2=MEDIAN(A2,B2,C2)





FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website

 If you would like to share this newsletter with others...
1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.

8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630