Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

how to formula the date in microsoft excel?

I'm doing Microsoft Excel assignment, but I am clueless on making formula that either add 10 or something like that to the date I started my assignment. Without typing the dates, but using Excel date function. Should not have TWO dates. But I kept getting 2 dates.

Anyone know how?

2 Answers

Relevance
  • IXL@XL
    Lv 7
    1 decade ago
    Favorite Answer

    A1 enter SHIFT+; (gives current date)

    A2 =A1+10

  • 1 decade ago

    You indicate 'using the Excel date function'.

    Select a cell and, for the current date, enter the formula:

    =DATE(YEAR(TODAY()), MONTH(TODAY()),DAY(TODAY()))

    Select the cell for the 'date + 10' and enter:

    =DATE(YEAR(TODAY()), MONTH(TODAY()),DAY(TODAY()+10))

Still have questions? Get your answers by asking now.