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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920