Comments on: Excel TODAY function to insert today's date and more

You want to put today's date in some cell? Or you wish to highlight the current date in your Excel calendar? Or you'd like to find the date closest to today? All this can be done by using the Excel TODAY function and this tutorial will teach you how. Continue reading →

Comments page 4. Total comments: 169

  1. I'd like excel to calulate the time between two dates to show how long someone was on a waiting list but when the second date is blank I'd like excel to calculate using today's date. I can do those two functions separately but not sure how to do them both together?

  2. Hello, can anyone please help. I have a list of renewal dates and I’m looking for an excel formula which will highlight in yellow, the dates which are less than 1 month from today. Thank you

  3. Hi,
    I'm always looking at prior day and getting it =TODAY()-1. How can I get the Fridays date on Monday by using TODAY() formula?

  4. Hi,
    I need like this formula,
    D36 is 15-Aug-2019
    =IF(AND(D36>TODAY(), AND((=TODAY()-D36)>=0, (=TODAY()-D36)<=10))),"Inside","Outside")
    When i use this one getting error, so please explain where i did mistake?
    thank you

  5. I WOULD TO HAVE ACCESS TO POWER PIVOT,POWER QUERRY COURSE,POWER B TUTORIAL

  6. how to freeze =now() or =today()? It must not change when we entered anywhere in cells
    =if(A2="",today(),"1")

  7. Hi I am using the TODAY formula in a roster to highlight the current date on a roster however it is highlighting the incorrect date, the date highlighted is two days ahead of the correct date.

  8. Hello- can really use help with this.....I have a list of assets in one column with just a number representing the value of how old each asset is.....I need a formula for another column- YEAR BUILT- so I need a YEAR formula that I can combine with TODAY()......I just can't figure out how to do it....I need to use TODAY(), because this would be an ongoing list

  9. Hi

    Please help

    If I input on a cell number '1' then the current date will show, if '0' the cell leave blank.

    Thanks for help

  10. If have =+TODAY()+1 in cell that will give me tomorrow date, I want it will stop automatically when month will be over on 30th or 31st

  11. Hopefully someone will be able to tell me what i am doing wrong here. I have created a seperate worksheet that shows data for each day of the year as either "a" or "u". I'm wanting to create a formula that will count the number of occurences of "u" in the next 7 days and the next 30 days. Each formula I attempt throws an error as i can't figure a way to create a date range using todays date as the start point.
    I started with the below for counting out to 7 days
    =COUNTIFS('Calendar'!$2:$2,TODAY()+7,'Response'!3:3,"U") or =COUNTIFS('Calendar'!$2:$2,TODAY():TODAY()+7,'Response'!3:3,"U")

    Hopefully someone can help me. Thanks!!

  12. Hello, thanks for the post! It is very informative.
    I am working on a budget spreadsheet and I am trying to find the correct syntax for an IF ELSE formula for Excel. Here is my formula:
    IF(TODAY()>06/01/2019,G10-G11,"Not EOM")
    The goal is to have the program give the difference between income (G10) and expenses (G11) AFTER the end of the month. It doesn't seem to be recognizing the ">" sign. For it gives G10-G11. Can you help? Thanks!

    1. Not sure if your question was ever answered, but you could consider using the number format of the date, in your case 43471. This is how excel uses dates in calculations, and so may aid you.
      i.e.
      IF(TODAY()>43471,G10-G11,"Not EOM")

      Cheers,
      D

  13. Cell A2 =TODAY(), the data in cells B2:G2 fail to move down 1 row to A3 when A2's date is updated. I would also like the formatting from below to automatically be applied to B2:G2 as the new row is created. Thank you.

  14. Hello,
    if i enter in cell name of the task, the other cell need to show the date.
    kindly advice the format.

  15. Can somebody help me how to get the date of loyalty of employee in 10 years, example supposing he/she was hired March 03, 2008 then he got received loyalty award at March 03, 2018. This date will show in cell. Then if he/she 15 years of received he/she will received again loyalty award of 5 years. The date will also show when he/she will received that award. Thanks in advance. This is a great help for me! God bLess :)

  16. Hi Svetlana,
    Was wondering if there is a way to have excel change the year of a date entered. For example I enter 5/29 (and I have formatted cells to the 03/14/01 format), so excel returns 05/29/19. But I want a formula so that it returns 05/29/18. So same date just for last year?
    Thank you very much for your help. Love your name by the way.

  17. I have a list of events in column A with completion dates in column B. I use this formula to find out how many events have not been completed in one (1) year:
    =COUNTIF(B2:B202,"<2/4/2018")
    I manually put in the date as today's month and day and last year. Is there a way I can have Excel do that so it is always up to date without me having to manually entering the date? I tried this but it does not work: =COUNTIF(C2:C202,"<TODAY()-365")

    Thank you,
    Bob

  18. @ Svetlana Cheusheva: Thanks for saving a lots of time.

  19. I have the TODAY function in cell A1. I want cell G9 to update to the previous month/year. Ex. Today's date is 1/11/2019 in cell A1 so I want G9 to show December 2018. And then when A1 shows 2/1/19, I want G9 to show January 2019. Does a function and/or condition exist for this?

  20. Guys,
    I have all the dates for the year in column A starting in cell A2 from 01-Jan-19 through to 31-Dec-19. I used your guidance to create a rule to highlight the current day (thanks). I would like to create a rule so that all of the days that are now past would be in a gray text colour, whereas the current date and future dates remain in a black font colour. Any advice much appreciated.

    1. =C1:C99<TODAY()-30

      this has highlighted for me the dates that are 30 days past from today. I use this in my outreach sheet to keep relationships current

  21. How do I auto fill just the current Month?Like December, January or February in a cell every time I open the document? I am making forms that I only want the month not today's date

    1. Hello, Jim:
      To enter the current month in a cell enter this formula in the cell:
      =TEXT(TODAY(),"mmmm")

  22. Hi,

    How do you add the time to the Excel formula for today's date? Using the formula,

    =CONCATENATE("Today is: ",TEXT(TODAY(), "dd mmmm yyyy hh:mm:ss"))

    I get "Today is: 25 October 2018 00:00:00" -- and not the current time, no matter what time it is. Even after reading many, many, websites on this topic, I am still confused (or rather, more confused), and I'm not really sure how the time stamp can still be added.

    Thanks and much appreciated,
    R

    1. Use NOW(), not TODAY(). TODAY() is only the date, NOW() includes the time.

  23. Dear Everyone

    May anyone can help me please
    i would like to have a function that when we key in today it will be show date today this date will be not change since we already move to next day..
    or When we key in on one cell date today will show automatically.

    Thank you so much

  24. I have a column of dates with some empty cells - how can i fill in all the empty cells with today's DATE?

    1. Mandi:
      TODAY() will give you today's date. If you enter this function in a cell, the cell will always display the current date.

  25. HI Steve
    can you suggest me a formula, where i need current date in date coloum if i make any change in that particular Row.

    6-May-18 . Linson N/A N/A 20-Jun-17 20-Jun-17

    so if make any change in any details by previous date (6-May-18) should become current date.

    1. Linson:
      I believe if you want a cell to update based on change to another cell it requires some code. In this case I think you could use some VBA, but VBA is not in this blog's frame. If you wanted to tackle this you could google "excel update cell if another cell changes".

  26. Hello Svetlana, where you're from, Ukraine or Russia? :)
    Nice job!
    Thanks you dear...

    1. Thank you, Louis. I'm from Belarus :)

      1. Thanks its help me a lot

  27. THANK YOU. A million times, THANK YOU!!!

  28. Steve:
    Enter this into cell B2 adjacent to cell A2
    =IF(ISNUMBER(A2),(TODAY()+21),"")
    then copy the formula down the B column.

  29. Can you help please? I have a spreadsheet on which I want to do the following: if I enter a number in a cell in Col A I want the adjacent cell in Col B to return a date which is today plus 21 days. If no number is entered in a cell in Col A I want the adjacent cell in Col B to remain blank. So:
    Col A Col B
    2 today's date + 21 days is returned

    3 today's date + 21 days is returned
    1 today's date + 21 days is returned

    1. Can we get a trend of values based on today fuction.I am using the todays value to divide expenses to get the average expenses daily

    2. Hi Steve,

      Supposing your data begins in row 2, you enter the following formula in B2, and then copy it down the column:
      =IF(ISNUMBER(A2), TODAY()+21, "")

      1. Thanks you much , its more useful.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)