Using the Excel Today Function to Set Target Dates

My entire playlist of Excel tutorials: bit.ly/tech4excel Learn about the TODAY function in Excel, which produces the current date. In this video we'll explore how you can use that function to do some really useful and pretty exciting things in Excel. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the link to a practice file to go with this tutorial: bit.ly/exceltodayfunction

[@CoreyLaGray]

I love it when I search for something on KZbin and find EXACTLY what I'm looking for. Thank you.

[@TheJrockfreak]

Im a microsoft office tutor at my local technical college so video like this help me stay updated with information especially these functions, Thank you

[@andieo7785]

Amazing! Please make more videos using time/date functions if you can. These are so helpful!

[@harrykingsley2585]

Very well explained. Need more of these videos on formulas

[@svijayiitk]

So useful! Thank you for sharing this!!!

[@byusuf4953]

Extremely useful! 👋🏾👋🏾👋🏾 Thank you for sharing.

[@xCantalupox]

You always make great tutorials, thx : )

[@sahirac7817]

God bless you.this helps so much

[@Low.Key.Music01]

I didn't know such a thing existed on Excel. Thank you!

[@Teacherman1955]

When I tried this operation for the first example, the answer came out as another date. 1/17/1900. I then formatted the cell that the answer appeared in as general and the answer appeared in the proper format; as a number.

[@madhujakashyap8408]

This was the same problem with me and I got the solution after reading your comment. Thank you 💜

[@shahdmousa304]

Thank you your comment was helpful!

[@leelopez160]

Thank you for this.

[@nabilasenia9092]

Bless you! Thank you so very much!

[@kavyat3317]

That's very helpful video about today. And what is the function for automatic count of the days that are recorded in the above? Will the number of days change with the next date?

[@Vafzli]

Great trick it will safe a lot of time

[@tonycastelino547]

The 3 C's. Clear, Complete and Concise. What a great Teacher.

[@nunemg572]

Thank u, nice day to you ))

[@shalinialjapur505]

Really so help video. Thank you for sharing 👍👍

[@excel-curiosityforlearning5277]

Hello Shalini, we have few interesting excel tutorial on our channel do visit

[@muhammadluqmankhidhr5415]

Thank you very much

[@musicfun6514]

Good knowledge

[@UNDERDOG550]

thanks man this tutorial was fairly helpful

[@techteachersandstudents]

I'll take it. Thanks for watching.

[@michaelanderson4664]

You can alse add the "$" in front of the "A" and "1" in the formula so you don't have to write the dates multiple times on Sheet 1.

[@kulinterests]

When you sue the today( ) will the today date be constant or will it update to the current date as days change, will the date change?

[@moonbee03]

Hi! Thank you for this. Could I please ask for your help with an issue. I am using an excel template for any given calendar month of any given year. I now have 12 tabs at the bottom, one for each month. But... I am staring in October, and everything is wonderfully automated (drop down when I choose the moth, it changes all the cells for the numbers of the days and for Mon, Tue, etc automatically)... But the rest of the tabs are meant for next year and when I try and change the year, I don't get a drop down to choose from, I get this formula =YEAR(TODAY()) How can I turn that into 2023? Thank you for any help you can provide.

[@parulisha]

Any video on checkifs maxifs etc.

[@karljo8064]

very helpful. I love these short lesson.

[@excel-curiosityforlearning5277]

Hello Karl, even I have made videos on excel which are short and informative. Do visit

[@Mhmd06]

no need to ask if we found the video helpful everytime because the answer is always YES!

[@jamesfarnham1976]

Great tip. Question? Does Excel recognize leap years? Thanks for all you do. Jim.

[@techteachersandstudents]

The Today function bases the calculations off of the computer's time setting. So as long as the computer itself recognizes leap years (which I'm pretty sure it does), then Excel should handle it just fine. Thanks for watching.

[@rishigusain8668]

Applied the same formula and trick..but it's not showing the numbee of days instead showing the entire format month day date

[@KC_47.]

Sir, how to make today - 1 day = yesterday (in dd/mm/yyyy)?

[@AmbalalSingh]

Same problem

[@sonjabaria4324]

Hello! I've encountered a delay in the date that today() returns. I think it has something to do with the timezone but I don't know how to correct it. For example, I use it today. I live in PH so it must return Oct 21. But it returns Oct 20. How do you I troubleshoot this?

[@Amara.Bayarm]

I can't find Ribbon from Preferences, view. How can't customise the ribbon. Anybody knows how to customise when I can't find ribbon on preferences menu? Thank you

[@AviatorStone]

I would like to ask you a bit of a complicated excel question

[@ahmadmohamed2361]

if i put =today() or =now() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell

[@harimani607]

when i tried excel shows this formula is missing range reference or a defined name, what to do

[@s.m.alamin1328]

Summarize : Need two sheets : write down your expecting days on one sheet. Then open another one use the function : TODAY()

[@engineerhanifullah8737]

Please explain how to stop the Today formula for example i have two dates 22/08/2020 and target dates 19/09/2020 So the today formula is calculating the over days i want to stopped it on balance day zero Could you please make a video on it or here in comments can explain

[@saraholu-jide4430]

right click and press format cells. then change it to general

[@donfransisco9404]

does not have to be 5 minutes long bro