In the Less Than dialog enter =today() as your criteria and then click on OK. To do this we need to select the dates and then on the Ribbon’s Home tab, the Styles group click on the Conditional Formatting menu.įrom the menu select Highlight Cells Rules and then Less Than… We could also use the TODAY function to conditionally format the due dates that are overdue. We need to format the cell to show a number and the copy the formula down the rest of the column. Initially Excel returns the answer as a date. We can use the TODAY function to perform this calculation =C2-today() In our example we are working on an invoice spreadsheet where we need to first of all calculate the number of days until an invoice is due. Watch the video, read the tutorial and download the featured file This is great news if you need a formula to work out whether an invoice is overdue or if you need to know the number of days left until a deadline. The TODAY function returns the current date – but will update itself when you open your worksheet on another day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |