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!

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

@ApexTrainingLLC

2 жыл бұрын

I'm glad it was helpful!

@pinkmark4047

2 жыл бұрын

@@ApexTrainingLLC bless you

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

@beaslyxbox

4 ай бұрын

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

@beaslyxbox

2 ай бұрын

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

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

@ApexTrainingLLC

3 жыл бұрын

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

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

@ApexTrainingLLC

3 жыл бұрын

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

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

@ApexTrainingLLC

7 ай бұрын

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

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

@ApexTrainingLLC

7 ай бұрын

Glad it helped!

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!

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

@ApexTrainingLLC

7 ай бұрын

Glad it helped!

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

@ApexTrainingLLC

6 жыл бұрын

+Brandon Thibeaux thank you for the feedback Brandon!!

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

@ApexTrainingLLC

2 жыл бұрын

Hello, I'm glad it was helpful!

Simple and straighforward. Thank you!

@ApexTrainingLLC

2 жыл бұрын

Thank you for checking out my video!

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

@ApexTrainingLLC

2 жыл бұрын

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

@niconicouana

2 жыл бұрын

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

Thank you, you just saved my job

@ApexTrainingLLC

7 жыл бұрын

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

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

@ApexTrainingLLC

3 ай бұрын

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

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

@ApexTrainingLLC

Жыл бұрын

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

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

You are a life saver... Thank you

@ApexTrainingLLC

Жыл бұрын

I'm glad you found it helpful Timothy!

It's very helpful thanks.

@ApexTrainingLLC

6 ай бұрын

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

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!

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

@ApexTrainingLLC

11 ай бұрын

Hi Caroline.... check out this video on the DATEDIF Function kzread.info/dash/bejne/Y4GespKjiMixgtI.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.

@ApexTrainingLLC

3 ай бұрын

Do you mean you want to know how many years between today() and another date? You might find this video useful... kzread.info/dash/bejne/fWaEx62TdKrUlso.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.

@ApexTrainingLLC

Жыл бұрын

kzread.info/dash/bejne/l6iCzsuyqpWwfJs.html

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

@ApexTrainingLLC

3 жыл бұрын

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

Helps! TY!

Thank you, it was to the point

@ApexTrainingLLC

Жыл бұрын

Thank you!

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

3 ай бұрын

check out this updated version... kzread.info/dash/bejne/d3uZk8-il9iuqrw.htmlsi=d1kInDOPre0rJaLQ

Thank you Rich

@ApexTrainingLLC

3 жыл бұрын

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

THANK YOU

@ApexTrainingLLC

4 ай бұрын

You’re welcome!!!

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

6 ай бұрын

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

Obrigado

@ApexTrainingLLC

2 ай бұрын

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

Thanks Rich Sir.. 😊 It's help alot

@ApexTrainingLLC

2 жыл бұрын

You're welcome. I'm 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

@ApexTrainingLLC

3 ай бұрын

Hello... I have a created a video for you.... kzread.info/dash/bejne/ZaeHmrane5WzqZs.html thanks for watching the channel, please subscribe and share!

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 ❤️

THANKS it was very easy and helpful

@ApexTrainingLLC

2 жыл бұрын

Hello Ashok, I'm glad it was helpful!

thank u so much

@ApexTrainingLLC

Жыл бұрын

You are most welcome

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... kzread.info/dash/bejne/a6eb0sVwgrDfgcY.html

Thank you so much!

@ApexTrainingLLC

Жыл бұрын

Glad it helped!

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

@ApexTrainingLLC

6 жыл бұрын

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

@ritikabaluja1053

6 жыл бұрын

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

Thanks a lot great man

@ApexTrainingLLC

2 жыл бұрын

Thank you!

Is that calculating with current date ?

@ApexTrainingLLC

2 жыл бұрын

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

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

THANK YOU!!

@ApexTrainingLLC

3 ай бұрын

You're welcome!

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... kzread.info/dash/bejne/Y4GespKjiMixgtI.html

Thank you so much

@ApexTrainingLLC

2 жыл бұрын

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

Thanks

@ApexTrainingLLC

Жыл бұрын

Any time!

thank you!

@ApexTrainingLLC

Жыл бұрын

You're welcome!

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?

how to do the reverse of it ??

@ApexTrainingLLC

Жыл бұрын

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

Hi Rich, will this function update automatically every day?

@ApexTrainingLLC

7 ай бұрын

Yes indeed!

What if want in month date year format

@ApexTrainingLLC

3 ай бұрын

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

Thank you

@ApexTrainingLLC

Жыл бұрын

You're welcome Diana!

your voice is so nice!

@ApexTrainingLLC

6 жыл бұрын

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

@ApexTrainingLLC

3 жыл бұрын

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

Thanks!

@ApexTrainingLLC

Жыл бұрын

You're welcome!

Cool

@ApexTrainingLLC

8 күн бұрын

Thanks! Please like, share and subscribe. Peace!

Vug Aguilera. B

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

6 ай бұрын

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

6 ай бұрын

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

Pls help me can you share me the steps with keys

in my excel, it comes error

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

@ApexTrainingLLC

2 жыл бұрын

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

@libinchacko7883

2 жыл бұрын

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

why this method didn't work for me?

@ApexTrainingLLC

Жыл бұрын

Hi, did you get an error?

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

Exactly what’s I was looking for!👍👍

@ApexTrainingLLC

6 ай бұрын

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

Thanks

@ApexTrainingLLC

4 жыл бұрын

You're welcome!

Thanks

@ApexTrainingLLC

Жыл бұрын

You are welcome Sameer