Katameksp

Insert Today's date button in Excel daveinuk (TechnicalUser) (OP) 25 Sep 05 1717 Hi All Can one of you tell me how to create a button in Excel that will insert todays date into a cell Many thanks D RE Insert Today's date button in Excel Zathras (Programmer) 25 Sep 05 1724 You already have it <Ctrl>;<Enter>Set cell B1 to today's date using the formula "=now ()" without quotes That way, the date will always be current List the project due dates in column B In column C next to the due dates, add a formula to calculate the difference between the due date and today's dateThis wikiHow teaches you how to insert today's date into a cell in your spreadsheet If you want the date in the cell tp always remain the same (static), you can enter the date with a keyboard shortcut If you'd rather the cell change to display the actual date every time the file is opened (dynamic), you can use a formula Entering a Static Date Open your project in Excel You can