Do you mean you want to know how many years between today() and another date? You might find this video useful... th-cam.com/video/K2PeKZDGnfg/w-d-xo.htmlsi=v6eOSE8K8zu4Ssvn
Is there a way to directly have output of Today() as dd/mm/yy instead of mm/dd/yy. Not asking about formatting. I know how to change it manually. I want to have output as dd/mm/yy whenever I use Today() function.
Hi Sir, can I ask for help: I need a formula that counts: date created vs today and that counter will stop once their is a date already in the approved date column? I will be very grateful of your help. God bless you.
Hi I’m having difficulty applying this formula to multiple cells at a time . I want it to be automatic when I enter a date in column b I want it to generate how many days it’s been since in colomn g
Hi Dede! Thanks for.your question, once you right the formula in the first cell in column G, you need to copy the formula down for the additional cells. See the part near the end ofll the video where I copy the formula down...
How do I create different tasks (lets say in a drop down) but some have 14 day target date and some have 21? ie, if its a postal complaint i have 21 days to respond, if its email I have 14
you mean freeze it as of a certain date? Then don't use the TODAY() function. Just use a certain date. By the way, there is now a DAYS function you can use, instead of subtracting dates from each other... th-cam.com/video/9sgpc7RMyQc/w-d-xo.html
There are several ways. One way is to simply take the result of this formula and divide by 365.25. Another way is with the DATEDIF function, which I have a video on... th-cam.com/video/1MjP0jXeKRo/w-d-xo.html
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?
Hi Sonja! Does this happen every time you use the TODAY() function? The function gets the current date from your computer's internal clock. Is the date correct on your computer when this happens?
Hi Sir, thank you for sharing this! also, I would like to know if there is any simple way like this to calculate remaining days, from today to specific date. kinda like the count down, it's for something like remaining days for subscription or promo. thank you ^_^
I'm glad it was useful for you. Yes! To calculate the remaining days, you simply subtract today's date from the future date. Suppose you have a promo that ends on March 31st. You could write ="3/31/2024" - TODAY() Or if the promo expiration date was in a cell, for example, B5. You would write: =B5 - TODAy() as your formula.
@@ApexTrainingLLCah why didn't I think about it before, actually it might be similar to what I used to do, I put the 2 dates (exp and today) in the cell and substract them. But I have no idea that I can also use =TODAY instead of typing the date manually. On the second thought, it's not always the 'today' date that I want to calculate, sometimes it's different date, so I can't always use =TODAY formula. Anyway thank you for the explanation and for replying my comment Sir, I really appreciate it 😊
Thank you for your inquiry! If you don’t want the today function to keep updating, just copy it and paste the value. Then the formula will be gone, and only the current date will remain.
I just spent 30 mins trying to find out how to format that 1900 dated cell, it took me 90 seconds with this video! Thank you!
Glad I could help!
I literally come back to this video every other month. Thanks Rich.
came back today lol. see myself again in 2 months when i need help again
I am back again today may 7th 2024 because i forgot. see myself in another 3 months
8 years later and you saved my life.
Thank you.
🙏🙏
I'm glad it was helpful!
@@ApexTrainingLLC bless you
This is exactly what I needed. Thank you so much for getting right to the point.
Thank you Crissie... I hope you will subscribe! :-) Have a great day
Thank you Rich! I viewed three other videos, no one explained as well as you.
Glad it helped! Thank you so much for the feedback Stephanie!
the BEST instruction on getting done what I needed. Thank you!!!
Thank you for your comment! Please subscribe! More videos to come soon!
This was so easy to follow along with and a lot less complicated than I thought
I'm glad it helped Emily! Have a great day!
Clear, concise and easy-to-follow video. Cheers!
Glad it helped!
Exactly what’s I was looking for!👍👍
Thank you for the comment! I am glad it helped!
OMG!! Thank you so much! Exactly what I needed!!!
Glad it helped!
ive been looking for this tutorial for hourssssss hahahaha thank u so much!
Hi Karen!! I'm glad it was useful! Please subscribe! 😀
Search all over the internet for this answer! Thank you!
+Brandon Thibeaux thank you for the feedback Brandon!!
How would I calculate it if I wanted to know the years & months instead of days
Hi Caroline.... check out this video on the DATEDIF Function th-cam.com/video/1MjP0jXeKRo/w-d-xo.html
how to get time difference in xl from today () and any other time in any other cell ? The time must be in year format.
Do you mean you want to know how many years between today() and another date?
You might find this video useful...
th-cam.com/video/K2PeKZDGnfg/w-d-xo.htmlsi=v6eOSE8K8zu4Ssvn
It is very useful , thank you Sir, i don't need to use my fingers to count them any more : )))))))
Hi Andrea! I am glad you found it useful! Please subscribe! Have a great day!
Perfection. You are awesome and a great communicator. Thank you.
Thank you for your feedback Nicole. You made my day. I'm glad you found it useful!
@@ApexTrainingLLC You saved me so much precious time. I am very appreciative. Glad your day is made. Be well.
Is there a way to directly have output of Today() as dd/mm/yy instead of mm/dd/yy. Not asking about formatting. I know how to change it manually. I want to have output as dd/mm/yy whenever I use Today() function.
th-cam.com/video/etNliyz2JL8/w-d-xo.html
I used the same formula but if the value in first column is blank for next months, it picks random number of days because of formula
check out this updated version... th-cam.com/video/EGe1miguHzY/w-d-xo.htmlsi=d1kInDOPre0rJaLQ
You are a life saver... Thank you
I'm glad you found it helpful Timothy!
Thank you so much.
This is the formula i was looking for.
Hello, I'm glad it was helpful!
Thanks Rich Sir.. 😊 It's help alot
You're welcome. I'm glad it was useful!
Thank you, you just saved my job
+Urlisa Sankey Hi Urlisa! Thanks for watching. Please subscribe. Let me know if you want to see a video on anything else.
Hi Sir, can I ask for help: I need a formula that counts: date created vs today and that counter will stop once their is a date already in the approved date column? I will be very grateful of your help. God bless you.
Hey Jen. I will create a video for you for this later today!
thank you so much sir ❤️
Thank you so much, this video was so useful, keep up the good work and I have subscribed of course
Awesome, thank you so much!
What if want in month date year format
Greetings. The original date in the video is in month/day/year format... Perhaps I don't understand the question....
Hi I’m having difficulty applying this formula to multiple cells at a time . I want it to be automatic when I enter a date in column b I want it to generate how many days it’s been since in colomn g
Hi Dede! Thanks for.your question, once you right the formula in the first cell in column G, you need to copy the formula down for the additional cells.
See the part near the end ofll the video where I copy the formula down...
how to keep cells of the age day coulom blunk if there are no date in the invoice date
Use IF to check if there is a value in the invoice date column
See my videos on the IF function
THANKS it was very easy and helpful
Hello Ashok, I'm glad it was helpful!
Thank you, it was to the point
Thank you!
Simple and straighforward. Thank you!
Thank you for checking out my video!
It's very helpful thanks.
Thank you so much! I am glad it was useful!
How do I create different tasks (lets say in a drop down) but some have 14 day target date and some have 21? ie, if its a postal complaint i have 21 days to respond, if its email I have 14
Hello... I have a created a video for you.... th-cam.com/video/3sS8TnK2My8/w-d-xo.html
thanks for watching the channel, please subscribe and share!
Just wanna ask how to stop that formula from counting the number of days??
you mean freeze it as of a certain date? Then don't use the TODAY() function. Just use a certain date. By the way, there is now a DAYS function you can use, instead of subtracting dates from each other... th-cam.com/video/9sgpc7RMyQc/w-d-xo.html
Easy way. Thank you so much.
Great! You are so welcome. Please don't forget to share, like and subscribe. Thanks!
Is that calculating with current date ?
The TODAY function is the function in Excel for the current date.
how do u get the amount of years instead of days?
There are several ways. One way is to simply take the result of this formula and divide by 365.25. Another way is with the DATEDIF function, which I have a video on... th-cam.com/video/1MjP0jXeKRo/w-d-xo.html
I tried, it prompts back 'VALUE' and not any number
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?
Hi Sonja! Does this happen every time you use the TODAY() function? The function gets the current date from your computer's internal clock. Is the date correct on your computer when this happens?
how to do the reverse of it ??
Just flip the position of the today function and the date value.
Nice.I found it useful.I am subscribing it.
Thank you very much. I'm glad it was useful!
I am getting a value or name error when I do this. Any ideas?
Elliott, check the spelling, you may have a typo. It should read =TODAY()
Spelling are correct... But in my personal computer showing error.. In my office computer showing correct value
THANK YOU
You’re welcome!!!
Thank you Rich
Thanks for visiting the channel Priscilla! Let me know if there is anything else you need a video on.
hi
if i have to add 'days' after 104... how to do that?
+Ritika Baluja Hi Ritika! I don't think I understand the question. You want to add 104 days after today?
Rich Kerr Hi Rich Kerr i want to know that how to add 'days' after number.. now i get a solution today ()-text (" ",&&"days")
Hi Sir, thank you for sharing this!
also, I would like to know if there is any simple way like this to calculate remaining days, from today to specific date. kinda like the count down, it's for something like remaining days for subscription or promo.
thank you ^_^
I'm glad it was useful for you. Yes! To calculate the remaining days, you simply subtract today's date from the future date.
Suppose you have a promo that ends on March 31st. You could write ="3/31/2024" - TODAY()
Or if the promo expiration date was in a cell, for example, B5. You would write: =B5 - TODAy() as your formula.
@@ApexTrainingLLCah why didn't I think about it before, actually it might be similar to what I used to do, I put the 2 dates (exp and today) in the cell and substract them. But I have no idea that I can also use =TODAY instead of typing the date manually.
On the second thought, it's not always the 'today' date that I want to calculate, sometimes it's different date, so I can't always use =TODAY formula.
Anyway thank you for the explanation and for replying my comment Sir, I really appreciate it 😊
why this method didn't work for me?
Hi, did you get an error?
Thank you so much!
Glad it helped!
Thank you so much
You're welcome! I'm glad you found it helpful!
thank u so much
You are most welcome
Thanks a lot great man
Thank you!
How to stop the today function?
Thank you for your inquiry! If you don’t want the today function to keep updating, just copy it and paste the value. Then the formula will be gone, and only the current date will remain.
Obrigado
de nada. obrigado por visitar o canal. por favor inscreva-se!
thank you!
You're welcome!
Helps! TY!
Thank you
You're welcome Diana!
Pls help me can you share me the steps with keys
in my excel, it comes error
Thanks
You're welcome!
Thanks!
You're welcome!
your voice is so nice!
+Vân Thiên thank you! Please subscribe!
Let me know if i can create other videos for you!
Cool
Thanks! Please like, share and subscribe. Peace!
Hi Rich, will this function update automatically every day?
Yes indeed!
Vug Aguilera. B
To add 5 days to today's date... =TODAY()+5
Thank you so much
You are very welcome. Thank you!
THANK YOU!!
You're welcome!
THANK YOU
You are so welcome! Please don't forget to share, like and subscribe. Thanks!
Thanks
You are welcome Sameer
Thanks
Any time!