Excel today's date formula 150304-Excel today date formula
Follow the steps to compare two dates in excel Look at the below data to compare dates in excel Now in cell C2, apply the formula as "==B2" Press Enter to get the result We have the same date in both columns, so we got TRUE as a result Drag the formula to the following columns as well to get the result Try this 1 Suppose Date of show is in cell and Today's date is in cell B2 2 In cell C2, enter this formula =B2 3 Click on cell C2 and go to Home > Conditional formatting > New Rule > Use a formula to determine which cells to format 4 In the Formula bar there, enter this formula To add 7 days or week to the current date, need to enter the following formula in a cell =TODAY ()7 OR =TODAY ()B13 Here either cell reference (B13) or 7 is used along with today function =TODAY ()B13 is entered in a cell "D13" Excel Today Function To Insert Today S Date And More Excel today date formula