How can I use an arrayformula like this on a date to show how many days its been since that date? I've seen it done but when I copy the process into my own work it comes out to a huge negitive number instead of a positive going up, and if I convert that number into a date it shows 1/9/1779 instead of the current date compared to the date already imput.
Love your style of video creation. Simple, to the point. No fat to it.
Thanks!
Thank you. Straight to the point!
You are literally a life saver
awesome and simple explanation, thanks a lot!
Thank you so much for making this video. I really appreciate you taking the time to do so! New subscriber here.
How can I make one column the date format and an other column time format using arrayformula?
How can I use an arrayformula like this on a date to show how many days its been since that date? I've seen it done but when I copy the process into my own work it comes out to a huge negitive number instead of a positive going up, and if I convert that number into a date it shows 1/9/1779 instead of the current date compared to the date already imput.
Hi
How To Set Color With Formula By Percentage In Google Sheet
I would suggest looking at conditional formatting to see if that fits your use case.
How to use arrayformula for sumifs before date.
I can arrayformula sumif for sumifs, but can not for date range
Hello Sir, please can you let me know the formula Automatically Insert a Blank Row below Each Group data in Google Sheets
You should wrap it in an IF(NOT(ISBLANK.
Thank you for the lesson!
Is there any reason to just copy down the formula instead of using ARRAYFORMULA?
Yeah, it's more simple. I usually just copy a simple formula myself if you really want to know!
this was so easy to follow thank you so much!!
Glad it was helpful!
Can we use the ARRAYFORMULA with chained, IF statements?
You should be able to. Try us it and let us know how it goes.
Hi Can you make a video on how to track timely views on TH-cam like every hour (not real time views)
Cheers man!
Cheers my friend.
THANK YOU
Thank you very much
You are welcome
感謝分享👍👍
Wow
Everyone skips the part to delete the zero.. 🤦♂️
Suckers