Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-2024-08-06· OpenAIAi2 WildChat-4.8M (AI2)

how to get tomorrow in excel

  1. User

    how to get tomorrow in excel

  2. Assistant

    In Excel, you can easily calculate tomorrow's date by using the TODAY() function, which returns the current date. To get tomorrow's date, you simply add 1 to it. Here’s how you can do it:

    1. Basic Formula:

      • Enter the following formula in a cell:
        =TODAY() + 1
        

      This formula will return tomorrow’s date based on the current date provided by the TODAY() function.

    2. Formatting the Date:

      • If the result is not displayed in your desired date format, you can change the cell format by:
        • Right-clicking the cell and selecting "Format Cells..."
        • In the "Format Cells" dialog, go to the "Number" tab.
        • Select "Date" from the Category list.
        • Choose your preferred date format from the available options and click "OK".

    Every time you open or refresh the workbook, Excel will automatically update the TODAY() function to reflect the current date, ensuring that =TODAY() + 1 always returns the correct tomorrow’s date.