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.
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.... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3sS8TnK2My8.html thanks for watching the channel, please subscribe and share!
Do you mean you want to know how many years between today() and another date? You might find this video useful... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-K2PeKZDGnfg.htmlsi=v6eOSE8K8zu4Ssvn
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...
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 😊
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?
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... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9sgpc7RMyQc.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... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1MjP0jXeKRo.html