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
Пікірлер: 45
I love it when I search for something on KZread and find EXACTLY what I'm looking for. Thank you.
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
Amazing! Please make more videos using time/date functions if you can. These are so helpful!
God bless you.this helps so much
Very well explained. Need more of these videos on formulas
So useful! Thank you for sharing this!!!
Thank you for this.
Extremely useful! 👋🏾👋🏾👋🏾 Thank you for sharing.
Great trick it will safe a lot of time
You always make great tutorials, thx : )
I didn't know such a thing existed on Excel. Thank you!
The 3 C's. Clear, Complete and Concise. What a great Teacher.
Bless you! Thank you so very much!
thanks man this tutorial was fairly helpful
@techteachersandstudents
2 жыл бұрын
I'll take it. Thanks for watching.
Thank u, nice day to you ))
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?
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
3 жыл бұрын
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!
Really so help video. Thank you for sharing 👍👍
@excel-curiosityforlearning5277
4 жыл бұрын
Hello Shalini, we have few interesting excel tutorial on our channel do visit
Thank you very much
Good knowledge
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.
very helpful. I love these short lesson.
@excel-curiosityforlearning5277
4 жыл бұрын
Hello Karl, even I have made videos on excel which are short and informative. Do visit
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.
no need to ask if we found the video helpful everytime because the answer is always YES!
Great tip. Question? Does Excel recognize leap years? Thanks for all you do. Jim.
@techteachersandstudents
4 жыл бұрын
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.
Any video on checkifs maxifs etc.
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?
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?
Sir, how to make today - 1 day = yesterday (in dd/mm/yyyy)?
@AmbalalSingh
Жыл бұрын
Same problem
Applied the same formula and trick..but it's not showing the numbee of days instead showing the entire format month day date
I would like to ask you a bit of a complicated excel question
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
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
Summarize : Need two sheets : write down your expecting days on one sheet. Then open another one use the function : TODAY()
when i tried excel shows this formula is missing range reference or a defined name, what to do
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
2 жыл бұрын
right click and press format cells. then change it to general
does not have to be 5 minutes long bro