Answer - Formulas in excel begins with equal sign (=).
You might be shocked to learn that dates and numbers cannot be compared using the Equal to the logical operator. For instance, the formula =A1=A2 will yield True as it should if the cells A1 and A2 contain the date "12/1/2022".
On the other hand, if you attempt =A1=12/1/2022 or =A1="12/1/2022," you will receive the error False. Excel records data as numbers starting with 1-Jan-1900, which is kept as 1. This is the key point. 12/1/2022 is saved with the number 41974. Since "12/1/2022" is not equivalent to 41974, Microsoft Excel reads it as a regular text string in the aforementioned calculations and returns False. Always enclose dates in the DATEVALUE function for the right outcome, as in =A1=DATEVALUE("12/1/2022").
Summary:
Formulas in Excel Begins with
Formulas in excel begins with equal sign (=). The formula bar at the top of an Excel sheet is where we can enter the formulas we want to employ for our calculations.
Comments
write a comment