Excel - TODAY Function

[@jodybrown2275]

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!

[@ApexTrainingLLC]

Glad I could help!

[@beaslyxbox]

I literally come back to this video every other month. Thanks Rich.

[@beaslyxbox]

came back today lol. see myself again in 2 months when i need help again

[@beaslyxbox]

I am back again today may 7th 2024 because i forgot. see myself in another 3 months

[@imperialpartymusic]

8 years later and you saved my life. Thank you. 🙏🙏

[@ApexTrainingLLC]

I'm glad it was helpful!

[@imperialpartymusic]

@@ApexTrainingLLC bless you

[@crissy8310]

This is exactly what I needed. Thank you so much for getting right to the point.

[@ApexTrainingLLC]

Thank you Crissie... I hope you will subscribe! :-) Have a great day

[@jessicacosentino1772]

the BEST instruction on getting done what I needed. Thank you!!!

[@ApexTrainingLLC]

Thank you for your comment! Please subscribe! More videos to come soon!

[@haroldasraz]

Clear, concise and easy-to-follow video. Cheers!

[@ApexTrainingLLC]

Glad it helped!

[@Stephanie-qz2op]

Thank you Rich! I viewed three other videos, no one explained as well as you.

[@ApexTrainingLLC]

Glad it helped! Thank you so much for the feedback Stephanie!

[@toninew5658]

OMG!! Thank you so much! Exactly what I needed!!!

[@ApexTrainingLLC]

Glad it helped!

[@emilyhungerford8600]

This was so easy to follow along with and a lot less complicated than I thought

[@ApexTrainingLLC]

I'm glad it helped Emily! Have a great day!

[@kareneee7724]

ive been looking for this tutorial for hourssssss hahahaha thank u so much!

[@ApexTrainingLLC]

Hi Karen!! I'm glad it was useful! Please subscribe! 😀

[@JRKDxb]

Exactly what’s I was looking for!👍👍

[@ApexTrainingLLC]

Thank you for the comment! I am glad it helped!

[@brand0able]

Search all over the internet for this answer! Thank you!

[@ApexTrainingLLC]

+Brandon Thibeaux thank you for the feedback Brandon!!

[@lillianpalmer2556]

Thank you so much, this video was so useful, keep up the good work and I have subscribed of course

[@ApexTrainingLLC]

Awesome, thank you so much!

[@niconicouana]

Perfection. You are awesome and a great communicator. Thank you.

[@ApexTrainingLLC]

Thank you for your feedback Nicole. You made my day. I'm glad you found it useful!

[@niconicouana]

@@ApexTrainingLLC You saved me so much precious time. I am very appreciative. Glad your day is made. Be well.

[@shraushanku3259]

Thank you so much. This is the formula i was looking for.

[@ApexTrainingLLC]

Hello, I'm glad it was helpful!

[@beautyishername2257]

Thank you, you just saved my job

[@ApexTrainingLLC]

+Urlisa Sankey Hi Urlisa! Thanks for watching. Please subscribe. Let me know if you want to see a video on anything else.

[@timothyagbamu7109]

You are a life saver... Thank you

[@ApexTrainingLLC]

I'm glad you found it helpful Timothy!

[@lavendano4921]

Simple and straighforward. Thank you!

[@ApexTrainingLLC]

Thank you for checking out my video!

[@souvikghosh5087]

Nice.I found it useful.I am subscribing it.

[@ApexTrainingLLC]

Thank you very much. I'm glad it was useful!

[@andreausa123]

It is very useful , thank you Sir, i don't need to use my fingers to count them any more : )))))))

[@ApexTrainingLLC]

Hi Andrea! I am glad you found it useful! Please subscribe! Have a great day!

[@CarolineDeSousa-o9n]

How would I calculate it if I wanted to know the years & months instead of days

[@ApexTrainingLLC]

Hi Caroline.... check out this video on the DATEDIF Function kzbin.info/www/bejne/Z37NgWOgjcp-iNE

[@shoaib_niazii]

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.

[@ApexTrainingLLC]

kzbin.info/www/bejne/m6WxnZyvr5d9gpo

[@kannank4144]

Thank you, it was to the point

[@ApexTrainingLLC]

Thank you!

[@sachinshinde250]

Thanks Rich Sir.. 😊 It's help alot

[@ApexTrainingLLC]

You're welcome. I'm glad it was useful!

[@ashokvithalani992]

THANKS it was very easy and helpful

[@ApexTrainingLLC]

Hello Ashok, I'm glad it was helpful!

[@harshmehta6748]

What if want in month date year format

[@ApexTrainingLLC]

Greetings. The original date in the video is in month/day/year format... Perhaps I don't understand the question....

[@9afi159]

Easy way. Thank you so much.

[@ApexTrainingLLC]

Great! You are so welcome. Please don't forget to share, like and subscribe. Thanks!

[@senglangsreng6766]

It's very helpful thanks.

[@ApexTrainingLLC]

Thank you so much! I am glad it was useful!

[@sukhjitkaur1978]

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

[@ApexTrainingLLC]

check out this updated version... kzbin.info/www/bejne/e3jIYqCfnNp7sLssi=d1kInDOPre0rJaLQ

[@dedeaguay7717]

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

[@ApexTrainingLLC]

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

[@soloparentwanderer]

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.

[@ApexTrainingLLC]

Hey Jen. I will create a video for you for this later today!

[@soloparentwanderer]

thank you so much sir ❤️

[@souvikghosh5087]

how to get time difference in xl from today () and any other time in any other cell ? The time must be in year format.

[@ApexTrainingLLC]

Do you mean you want to know how many years between today() and another date? You might find this video useful... kzbin.info/www/bejne/gWOzln6QeayhnMksi=v6eOSE8K8zu4Ssvn

[@priscillacarvajal9010]

Thank you Rich

[@ApexTrainingLLC]

Thanks for visiting the channel Priscilla! Let me know if there is anything else you need a video on.

[@AllanFaddes]

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

[@ApexTrainingLLC]

Hello... I have a created a video for you.... kzbin.info/www/bejne/aaS2aYekgJeAr5o thanks for watching the channel, please subscribe and share!

[@raffyjunp]

Just wanna ask how to stop that formula from counting the number of days??

[@ApexTrainingLLC]

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... kzbin.info/www/bejne/b6TKoZZth7Ksh8U

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

[@ApexTrainingLLC]

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?

[@mpesmail1834]

I tried, it prompts back 'VALUE' and not any number

[@BLackOpS2819]

Is that calculating with current date ?

[@ApexTrainingLLC]

The TODAY function is the function in Excel for the current date.

[@nicoled.3566]

Helps! TY!

[@Funnyvideos-do9wm]

Thanks a lot great man

[@ApexTrainingLLC]

Thank you!

[@SoshiKyo]

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 ^_^

[@ApexTrainingLLC]

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.

[@SoshiKyo]

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

[@awnalkhuwaytim9745]

how to keep cells of the age day coulom blunk if there are no date in the invoice date

[@ApexTrainingLLC]

Use IF to check if there is a value in the invoice date column

[@ApexTrainingLLC]

See my videos on the IF function

[@Geminicricketi]

how do u get the amount of years instead of days?

[@ApexTrainingLLC]

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... kzbin.info/www/bejne/Z37NgWOgjcp-iNE

[@KiaGuru]

Thank you so much!

[@ApexTrainingLLC]

Glad it helped!

[@screom30]

Thank you so much

[@ApexTrainingLLC]

You're welcome! I'm glad you found it helpful!

[@DDJEWEL-i7u]

THANK YOU

[@ApexTrainingLLC]

You’re welcome!!!

[@elliottduda5842]

I am getting a value or name error when I do this. Any ideas?

[@ApexTrainingLLC]

Elliott, check the spelling, you may have a typo. It should read =TODAY()

[@libinchacko7883]

Spelling are correct... But in my personal computer showing error.. In my office computer showing correct value

[@guesswho9541]

thank u so much

[@ApexTrainingLLC]

You are most welcome

[@ritikabaluja1053]

hi if i have to add 'days' after 104... how to do that?

[@ApexTrainingLLC]

+Ritika Baluja Hi Ritika! I don't think I understand the question. You want to add 104 days after today?

[@ritikabaluja1053]

Rich Kerr Hi Rich Kerr i want to know that how to add 'days' after number.. now i get a solution today ()-text (" ",&&"days")

[@harrymaguire7549]

how to do the reverse of it ??

[@ApexTrainingLLC]

Just flip the position of the today function and the date value.

[@lanakhamash1058]

why this method didn't work for me?

[@ApexTrainingLLC]

Hi, did you get an error?

[@mikefabrizio]

thank you!

[@ApexTrainingLLC]

You're welcome!

[@ayyukht]

How to stop the today function?

[@ApexTrainingLLC]

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.

[@thienvan3741]

your voice is so nice!

[@ApexTrainingLLC]

+Vân Thiên thank you! Please subscribe!

[@ApexTrainingLLC]

Let me know if i can create other videos for you!

[@dianapaul5930]

Thank you

[@ApexTrainingLLC]

You're welcome Diana!

[@kevinsantos585]

Obrigado

[@ApexTrainingLLC]

de nada. obrigado por visitar o canal. por favor inscreva-se!

[@Lebi-xn2ur]

Thanks!

[@ApexTrainingLLC]

You're welcome!

[@gillianbain7357]

Hi Rich, will this function update automatically every day?

[@ApexTrainingLLC]

Yes indeed!

[@chohanmohsin9435]

Thanks

[@ApexTrainingLLC]

You're welcome!

[@kamakshisharma7876]

in my excel, it comes error

[@Safety100]

Pls help me can you share me the steps with keys

[@mohammadzaman7383]

Cool

[@ApexTrainingLLC]

Thanks! Please like, share and subscribe. Peace!

[@elizabethcollinden8086]

Vug Aguilera. B

[@RichKerr]

To add 5 days to today's date... =TODAY()+5

[@ravikumark2333]

Thank you so much

[@ApexTrainingLLC]

You are very welcome. Thank you!

[@ibrahimal-saif9322]

THANK YOU!!

[@ApexTrainingLLC]

You're welcome!

[@chrisrhinehardt3765]

THANK YOU

[@ApexTrainingLLC]

You are so welcome! Please don't forget to share, like and subscribe. Thanks!

[@ilostmyticket]

Thanks

[@ApexTrainingLLC]

You are welcome Sameer

[@kaosermahamud]

Thanks

[@ApexTrainingLLC]

Any time!