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

[@harrykingsley2585]

Very well explained. Need more of these videos on formulas

[@CoreyLaGray]

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

[@andieo7785]

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

[@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

[@byusuf4953]

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

[@svijayiitk]

So useful! Thank you for sharing this!!!

[@xCantalupox]

You always make great tutorials, thx : )

[@Low.Key.Music01]

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

[@sahirac7817]

God bless you.this helps so much

[@leelopez160]

Thank you for this.

[@Mhmd06]

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

[@Vafzli]

Great trick it will safe a lot of time

[@nabilasenia9092]

Bless you! Thank you so very much!

[@tonycastelino547]

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

[@nunemg572]

Thank u, nice day to you ))

[@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?

[@shalinialjapur505]

Really so help video. Thank you for sharing 👍👍

[@excel-curiosityforlearning5277]

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

[@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!

[@muhammadluqmankhidhr5415]

Thank you very much

[@UNDERDOG550]

thanks man this tutorial was fairly helpful

[@techteachersandstudents]

I'll take it. Thanks for watching.

[@musicfun6514]

Good knowledge

[@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.

[@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

[@parulisha]

Any video on checkifs maxifs etc.

[@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.

[@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?

[@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

[@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?

[@s.m.alamin1328]

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

[@AviatorStone]

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

[@KC_47.]

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

[@AmbalalSingh]

Same problem

[@bayaraamara3378]

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

[@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

[@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