Excel - Formula to Detect If Date is Today but Why True/False Showing as 1/0 - Episode 1388

847 views · Published 21 April 2011 · 4:11 · Indexed 25 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: A Two condition formula to check if a date is today...another way to select a hyperlink cell without activating the hyperlink...why boolean formulas sometimes return 0 or 1 instead of False or True.

Welcome back to the MrExcel podcast. In this episode, we will be discussing a common issue that many Excel users face - project due dates. I'm Bill Jelen, and I'm here to help you navigate through this problem and find a solution that works for you.

In a previous episode, we talked about how to select a cell that contains a hyperlink. I had mentioned that you had to use the arrow keys, but it turns out that there is a much simpler way. Thanks to a tip from Bob in Kentucky, we now know that you can simply click on the cell and hold for about two seconds until the hand cursor changes to a plus sign. This effectively selects the cell without having to use the arrow keys. Thank you, Bob, for this helpful tip!

Now, let's move on to the main topic of this episode - project due dates. This question came in from a viewer who posted on my Facebook wall or sent me a message. They have a series of due dates and want to use a formula to determine if a project is due today. They have a great formula that uses a Boolean function, but they noticed something strange when they tried to use the same formula for a different purpose. Instead of getting true or false, they were getting 0's and 1's. After some investigation, it turns out that this spreadsheet was originally created in Lotus 123, which explains the unusual results. It's amazing how old software can still affect our current work in Excel.

Moving on to another question from Facebook, the viewer has added a new column to their spreadsheet to mark if a project has been paid. They want to modify their existing formula to also check for this new column. To do this, we can use the AND function to combine the original formula with a check for the new column. We can also use the ISBLANK function to check for any empty cells in the new column. However, we need to be careful about any potential spaces or capitalization in the data. It's important to consider all possibilities and choose the best method for your specific situation.

In this episode, we covered three important topics - selecting cells with hyperlinks, dealing with Lotus 123 remnants in Excel, and modifying a Boolean formula to include additional criteria. I hope these tips and tricks will help you in your Excel projects. Thank you for tuning in to the MrExcel podcast, and I'll see you next time for another informative episode.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Project Due 
(00:11) Selecting a Cell with a Hyperlink 
(00:33) Using a Boolean Formula 
(01:05) Puzzle for Viewers 
(01:15) Strange Formula Behavior 
(01:57) Wrapping the AND Function 
(02:43) Checking for Blank Cells 
(03:30) Recap of Three Topics 
(04:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Boolean formula
Case sensitivity in formulas
Checking for empty cells
Checking if something is paid
Episode 1388
Learn Excel
Lotus 123
Project Due
Selecting a cell with a hyperlink
Using the AND function in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153067/


This video answers these common search terms:
Boolean formula
Case sensitivity in formulas
Checking for empty cells
Checking if something is paid
Episode 1388
Learn Excel
Lotus 123
Project Due
Selecting a cell with a hyperlink
Using the AND function in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153067/

More from this channel