Hi! What a wonderful tutorial! Thank you so much. In case anyone else struggles with it, in some European countries, where commas are used as decimal separators, you need to change commas into backslash, so it looks as so: =SPARKLINE(D21;{"charttype"\"column";"ymin"\0%;"ymax"\100%;"color1"\"black"})
you know what.. your cmt is excactly what i looking for for weeks.. i changed the formula as you did, and it worked.. Thanks so muchhhhh p/s: Dành cho các bạn người Việt tìm đến Video này thì trong trường hợp hàm Sparkline bị lỗi Error (lỗi ko định dạng được công thức) thì hãy đổi các dấu "," trong hàm thành dấu "\",
I'm not very good at things like Google sheets or power point where there are a lot of tiny options that don't feel intuitive to me and with which I don't know what to do or how to utilise. Following this tutorial and achieving this spreadsheet truly did make me feel like a girl boss! Thank you!!
This was the BEST walkthrough ever. Not only did you give us instructions but you also gave us a few quick lessons that makes this customizable enough to fit my needs. I didn't know much at all before doing this and it was so easy that I feel comfortable enough to go through and make the other sheets you offer. You're amazing and this is awesome.
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
i am so thankful for this video i almost lost hope on finding a tutorial FOR BEGGINERS untill i found yours thank u so much please keep on sharing more of these best of luck
Happy New Year, everyone! 🎉 Just wanted to share that I've kickstarted my year by setting up this awesome goal chart on Google Sheets! 🚀✨ It's a fantastic way to visualize and track my goals throughout the year. Big shoutout to the video that guided me through the process! 🙌 May this year bring success, growth, and joy to each one of us.
I'm so happy to hear you kickstarted your year with this template! I hope you like it and I hope it helps you reach your goals! Happy New Year! 😊👩🏻💻✨🎉
you've helped me create something I've been trying to do for years. you also taught me more about excel than any course and i'm a grad student. thank you so much. Please make more content like this!
This was amazing to read! 💕 Thank you so much for taking the time to comment, I'm so happy you found it useful! 😊👩🏻💻✨ In case you would like to check it out this is a link to all my free tutorials thinklikeagirlboss.com/pages/free-youtube-tutorials 😊
Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many UA-cam channels selling templates, but I don't have enough money. This video truly helped me a lot.
I think this tutorial was awesome!!! 10/10 I really thought it was going to be extremely difficult, but you broke it down so well. Plus, I had fun learning! Thank you so much!
Did you say this was your first tutorial? Gosh! You delivered so well. It wasn't complex. I loved the steps you followed, the pace and the process. Thank you very much.
Thank you so much. I watched so many tutorials on how to do this. But this is the best I have come across. The way you explained every step in detail along with alternatives, its just amazing. Thank You!!!!
My nerdy side is kicking in. I think I love using the formulas too much, I've been coming back to your videos to learn more lol. Btw, I also purchased your monthly planner and I'm loving it!! I love how I can track where my hours are going.
Wow thank you so much!! I really appreciate you watching my videos and getting my products. I'm always so happy to hear that they are actually helping. Thank you for commenting! 😊👩🏻💻✨💕
I am so so thankful for your video! You explain things so easily, I absolutely loved working alongside this video of yours! Please keep on doing what you do! And a happy new year to you!
As a 12 year old, this was not as confusing as it looked. I got stuck on the last formula because it wasn't in the description. I figured it out, I couldn't see the comma on your screen as it was hazy (might just be for me though) But now I am done and I love it sm
Thank you for not only giving us a spreadsheet, but also explaining it to us so we can also learn the process behind it, which I find very important. I hope you have a wonderful beginning of the year 🤍
I usually don't comment on these kinds of tutorials but I loved it!! I followed through till the end of the video and enjoyed every minute of it! Thank you so much! I look forward to more tutorials from you!
This is excellent for someone who wants a refresher of various functions in Google Sheets. Please consider doing another video for absolute beginners and you explain it more slowly.
This is a great template, cheers 👍🏻 I would love to have seen conditional formatting on the Charts (25% = red, 50%= orange, 75% = green) This is a great start for tracking 'right now', or one you could add additional months to, but next level would be - for dates to 'store' the information (checkboxes) so that you get cumulative results (e.g. month chart, year chart, year on year.) - countif function for individual days, months etc, to see if (for example) Saturdays are a bad day for all habits, or Mondays are bad for habit 3. thanks for a thorough tutorial.
Hey, Thank you so much for this tutorial.. I'm able to apply it on my Habits tracker too... And this is my first time doing it,, since I am not good at spreadsheets,, but when I follow your tutorial... It was so easy,, This is one of my limiting beliefs since 2015 and I am able to do it.. . Looking for more tutorial s,, Thank you so much
Wow!! Thank you SO much for letting me know. I've wanted to do this types of videos for a long time but was scared I wouldn't do a good job, so I kept putting it off. I'm really glad you found it useful! Reading this makes me excited to keep making more 😊👩🏻💻 Thank you!!
@@thinklikeagirlboss Yah,, your tutorial is GREAT!! Here's what I've done by following your instruction: docs.google.com/spreadsheets/d/1aT6iabDJJaQq0uPslqLaQuBvWCY5RX1l9RpSSLiy11g/edit?usp=sharing
I just looked at it!! You have no idea how happy this makes me! Thank you so much for sharing it, this is exactly what I wanted, people using it as a base to create something completely original. 😊 Thank you so so much for showing this to me 😊👩🏻💻
Thank you so much for your expert guidance through the complicated coding needed to make this tracker. I have followed along, made my own, and duplicated the sheet to make one for next month. Amazing.
This is an amazing tutorial, I loved the design, and the tutorial is easy to follow along as a complete beginner. One thing is that you did not explain the last steps of decorating very clearly, when you were adding the different types of borders. Thank you so much!!
This tutorial is so helpful! If you're still taking video requests, I would love to learn how to make the auto-populated grocery list :) thanks again for your work!
Hi! Thank you so much for commenting! That's actually already on my list!! I'm trying to get better at making them faster so I hope I can come up with more tutorials soon 😊👩🏻💻✨
So happy I found this! I usually buy my complex spreadsheets but I do like the satisfaction of making one (sad life haha) Only part I got stuck on was the progress bars, I give up. Only had a full black cell. Thanks so much for the tutorial.
Powerful lesson! Thank you a lot to sharing decent experience! I tried different applications for tracking habits. But, personally for me this habit tracker is most efficient - you have plain overall view on all of your habits. And Google Sheet is every time available for free ) And you have a nice voice )
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
My dear lord! I spent my whole afternoon practicing the formulas but I feel so satisfied, thank you so much for this explanation. Quick question, is there a way to create pies to see how the tasks behaved compared to each other? Thank you so much for this content! Greetings from Colombia!
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
@@thinklikeagirlboss would you do a mood tracker, please? and if possible, could it have like a graph or something visual with colors to see how many days you have been in x mood easily. if it inst possible thank you anyway :)
Hi, Thanks I have mostly worked with Excel so that was a great video to learn some basic Sheets. I have an issue with dividing by 31 - if you add DAY(EOMONTH(D3,0) it will then divide by the number of day for that month. eg =COUNTIF(D4:AH4,TRUE)/DAY(EOMONTH(D3,0)) will give you a true Percentage. I Just happen to be working on this in a Leap year so it work for 29day in February. If you want to use conditional formatting to clear the unneeded dates and cheeks Custom formula is =AH3>TO_DATE(EOMONTH(D3,0)) and set text to White & fill to White.
By using AI (Artificial intelligence) all things can be done in few clicks but still I want to learn these things. They never taught me this in school, nor in college. I always wanted to learn this but too much busy with other assignments & work. So thanks a lot for your hard work. I'm your new subscriber! Well I still don't know your name but thank you so much, Madam
Hi! Thank you for watching! If you would like to check out the rest of my free tutorials you can find them linked here: thinklikeagirlboss.com/pages/free-youtube-tutorials 😊👩💻✨
Hi! What a wonderful tutorial! Thank you so much. In case anyone else struggles with it, in some European countries, where commas are used as decimal separators, you need to change commas into backslash, so it looks as so:
=SPARKLINE(D21;{"charttype"\"column";"ymin"\0%;"ymax"\100%;"color1"\"black"})
Hi! I'm so happy you liked it!! Thank you so much for your contribution!! I really appreciate it 😊👩🏻💻✨
you know what.. your cmt is excactly what i looking for for weeks.. i changed the formula as you did, and it worked.. Thanks so muchhhhh
p/s: Dành cho các bạn người Việt tìm đến Video này thì trong trường hợp hàm Sparkline bị lỗi Error (lỗi ko định dạng được công thức) thì hãy đổi các dấu "," trong hàm thành dấu "\",
@@viviennguyen8829 thank you so much, you saved me.
Thank you again, im from a spanish country and everything was a mess.. but this detail fix my error problem
lmao man, i just figured it out myself and then see ur comment right before i wanted to post that myself lol
I'm not very good at things like Google sheets or power point where there are a lot of tiny options that don't feel intuitive to me and with which I don't know what to do or how to utilise. Following this tutorial and achieving this spreadsheet truly did make me feel like a girl boss! Thank you!!
I'm so happy to hear this! Thank you!! If you learn a little bit at a time I'm sure you will master it in no time 😊👩🏻💻✨
This was the BEST walkthrough ever. Not only did you give us instructions but you also gave us a few quick lessons that makes this customizable enough to fit my needs. I didn't know much at all before doing this and it was so easy that I feel comfortable enough to go through and make the other sheets you offer. You're amazing and this is awesome.
I'm so excited you liked it and found it useful!! Thank you so much for watching and commenting! 😊👩🏻💻✨
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
i am so thankful for this video i almost lost hope on finding a tutorial FOR BEGGINERS untill i found yours thank u so much please keep on sharing more of these best of luck
I'm so happy you liked it! Thank you so much for watching! 😊👩🏻💻✨
Happy New Year, everyone! 🎉 Just wanted to share that I've kickstarted my year by setting up this awesome goal chart on Google Sheets! 🚀✨ It's a fantastic way to visualize and track my goals throughout the year. Big shoutout to the video that guided me through the process! 🙌 May this year bring success, growth, and joy to each one of us.
I'm so happy to hear you kickstarted your year with this template! I hope you like it and I hope it helps you reach your goals! Happy New Year! 😊👩🏻💻✨🎉
you've helped me create something I've been trying to do for years. you also taught me more about excel than any course and i'm a grad student. thank you so much. Please make more content like this!
This was amazing to read! 💕 Thank you so much for taking the time to comment, I'm so happy you found it useful! 😊👩🏻💻✨
In case you would like to check it out this is a link to all my free tutorials thinklikeagirlboss.com/pages/free-youtube-tutorials 😊
i have been taking therapy and didn't know how to make a habit tracker. you explained it simply. keep up the good work. amazing video. thank you.
Thank you so much!! I'm so happy you liked it!! 😊👩🏻💻✨
Omg, thank you so much! This tutorial is freaking amazing!! A lot of details and your explanations were so smooth and clear!!
I'm so happy you liked it! Thank you for watching! 😊👩💻✨
Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many UA-cam channels selling templates, but I don't have enough money. This video truly helped me a lot.
I'm so glad it helped you! Thank you for watching! 😊👩🏻💻✨
Thank you for this detail-oriented explanation!! It helps me a LOT
I was able to follow along nearly real time with minimal pauses and have now finished my beautiful sheet. Thank you :)
I'm so happy you were able to follow along! Thank you for watching! 😊👩🏻💻✨
I think this tutorial was awesome!!! 10/10 I really thought it was going to be extremely difficult, but you broke it down so well. Plus, I had fun learning! Thank you so much!
I'm so happy you found it useful!! Thank you so much for commenting!! 😊👩💻✨
Did you say this was your first tutorial? Gosh! You delivered so well. It wasn't complex. I loved the steps you followed, the pace and the process. Thank you very much.
Thank you so much!! I'm so happy you liked it!! 😊👩💻✨
Thank you so much. I watched so many tutorials on how to do this. But this is the best I have come across. The way you explained every step in detail along with alternatives, its just amazing. Thank You!!!!
I'm so happy you liked it! Thank you so much for watching it! 😊👩💻✨
Oh my god I've been looking for you all day and didn't realize it until now. Thanks for putting this together. I love you.
I loved reading this! Thank you so much for watching!! 😊👩💻✨💕
I searched everywhere for something like that and finally I found exactly something like this that too for free, thank you so much
I CAN'T BELEVE THAT TUTORIAL ARE FREE !!! THANK YOU FOR THAT
My nerdy side is kicking in. I think I love using the formulas too much, I've been coming back to your videos to learn more lol. Btw, I also purchased your monthly planner and I'm loving it!! I love how I can track where my hours are going.
Wow thank you so much!! I really appreciate you watching my videos and getting my products. I'm always so happy to hear that they are actually helping. Thank you for commenting! 😊👩🏻💻✨💕
I am so so thankful for your video! You explain things so easily, I absolutely loved working alongside this video of yours! Please keep on doing what you do! And a happy new year to you!
I'm glad it was helpful! Thank you for watching! 😊👩🏻💻✨
I never thought that I could learn so much from a single youtube video
I'm so happy to hear that!! Thank you so much for commenting 😊👩🏻💻✨
As a 12 year old, this was not as confusing as it looked. I got stuck on the last formula because it wasn't in the description. I figured it out, I couldn't see the comma on your screen as it was hazy (might just be for me though) But now I am done and I love it sm
Hi! Thank you so much for watching!! I'm so happy you were able to figure it out!! 😊👩💻✨
Amazing step by step tutorial! I found it so helpful for 2023, thank you so much!!
I'm so happy to hear that! Thank you!! 😊👩💻✨
this is the best habit tracker tutorial i ever watch, and also the way u explaining the function really helping me, thank you so much
Thank you so much for watching! I'm so happy to read you liked it! 😊👩💻✨
Thank you for not only giving us a spreadsheet, but also explaining it to us so we can also learn the process behind it, which I find very important. I hope you have a wonderful beginning of the year 🤍
I'm so happy you found it useful!! Thank you so much for your comment I loved it!! 😊👩💻✨
Girlie why are you so good i mean why do you do this for the world are you an angel god sent omg
You're so sweet, thank you!! 😊👩🏻💻✨💕
I appreciate your effort, this is what I was looking for.
I'm so happy to hear that! Thank you so much for commenting!! 😊👩💻✨
I usually don't comment on these kinds of tutorials but I loved it!! I followed through till the end of the video and enjoyed every minute of it! Thank you so much! I look forward to more tutorials from you!
Thank you SO much!! I'm so happy you liked it and decided to comment, I really appreciate it!! 😊👩🏻💻✨
This is excellent for someone who wants a refresher of various functions in Google Sheets. Please consider doing another video for absolute beginners and you explain it more slowly.
Million thanks to your tutorial on spreadsheet- your precise explanation is priceless❤️
Thank you so much for watching! 😊👩🏻💻✨💕
This is a great template, cheers 👍🏻
I would love to have seen conditional formatting on the Charts (25% = red, 50%= orange, 75% = green)
This is a great start for tracking 'right now', or one you could add additional months to, but next level would be
- for dates to 'store' the information (checkboxes) so that you get cumulative results (e.g. month chart, year chart, year on year.)
- countif function for individual days, months etc, to see if (for example) Saturdays are a bad day for all habits, or Mondays are bad for habit 3.
thanks for a thorough tutorial.
Hey, Thank you so much for this tutorial.. I'm able to apply it on my Habits tracker too... And this is my first time doing it,, since I am not good at spreadsheets,, but when I follow your tutorial... It was so easy,, This is one of my limiting beliefs since 2015 and I am able to do it.. . Looking for more tutorial
s,, Thank you so much
Wow!! Thank you SO much for letting me know. I've wanted to do this types of videos for a long time but was scared I wouldn't do a good job, so I kept putting it off. I'm really glad you found it useful! Reading this makes me excited to keep making more 😊👩🏻💻 Thank you!!
@@thinklikeagirlboss Yah,, your tutorial is GREAT!! Here's what I've done by following your instruction: docs.google.com/spreadsheets/d/1aT6iabDJJaQq0uPslqLaQuBvWCY5RX1l9RpSSLiy11g/edit?usp=sharing
I just looked at it!! You have no idea how happy this makes me! Thank you so much for sharing it, this is exactly what I wanted, people using it as a base to create something completely original. 😊 Thank you so so much for showing this to me 😊👩🏻💻
Thank you so much for your expert guidance through the complicated coding needed to make this tracker. I have followed along, made my own, and duplicated the sheet to make one for next month. Amazing.
I'm so glad you liked it!! Thank you for watching and commenting! 😊👩🏻💻✨
Thank you so much for this tutorial!! So helpful and concise!! I’m definitely going to use this to make my habit tracker ❤
So grateful to you for making videos like this. You're helping so many people.
It's really nice of you to say this! Thank you so much! I'm glad you found it useful 😊👩💻✨
thank you for helping us! this is worth it than any apps I tried before@@thinklikeagirlboss
I came across this randomly, but it's so good! Thank you very much :D
Thank you so much for watching!! 😊👩🏻💻✨
Its very informative and helpful for me. I really needed such tracker for my course. Thank you❤ now i know few things about sheets🙃
I had waaaaay too much fun following this along!!!!
I'm so happy you found it fun!! Thank you for watching! 😊👩💻✨
This is really what I need ❤ thankyou so much, sending love from Indonesia ❤❤
I'm so glad it was what you needed!! 😊👩💻✨💕
This is an amazing tutorial, I loved the design, and the tutorial is easy to follow along as a complete beginner. One thing is that you did not explain the last steps of decorating very clearly, when you were adding the different types of borders. Thank you so much!!
This tutorial is so helpful! If you're still taking video requests, I would love to learn how to make the auto-populated grocery list :) thanks again for your work!
Hi! Thank you so much for commenting! That's actually already on my list!! I'm trying to get better at making them faster so I hope I can come up with more tutorials soon 😊👩🏻💻✨
What an amazing tutorial! I'm definitely going to use the things I learned here, thank you so much!
I'm so excited to hear that!! 😊👩💻✨ Thank you so much for commenting!! I will definitely keep on making content like this 😊
I agree with most of these comments. This tutorial was very well done! I'm excited to create a tracker for the new year (:
Thank you so much!!! I'm so happy to hear that!! 😊👩💻✨
Thank you for walking us through this whole process. You are so helpful!
I'm so happy it helped you!! Thank you for watching and commenting! 😊👩💻✨
This tutorial was really well explained and easy to follow. I am now happy with my tracker. Thank you!
I'm so glad you liked it! Thank you for commenting! 😊👩💻✨
Thank you so much , i admired the channel name and your way of teaching is incredible ! god bless you
Thank you so much!! 😊👩💻✨💕
Mk te amo, es el mejor tutorial que he visto. Le pusiste mucho empeño, gracias por eso!❤😘🥰
Muchísimas gracias!! 😊👩🏻💻✨💕
you're so kind for sharing this wonderful tutorial video, thank you so much!! 💖💖
Thank you girl for this amazing tutorial❤YOU are doing the Lord’s work
So happy I found this! I usually buy my complex spreadsheets but I do like the satisfaction of making one (sad life haha) Only part I got stuck on was the progress bars, I give up. Only had a full black cell. Thanks so much for the tutorial.
Hi! Don't give up! Can you select that black cell and use the paint bucket to change the background color to white? And see if that fixes it? 😊👩💻✨
@@thinklikeagirlboss I wish I had but I have gone past there & now don’t know how to go back & fit in. I’m still pretty happy with it.
Powerful lesson!
Thank you a lot to sharing decent experience!
I tried different applications for tracking habits. But, personally for me this habit tracker is most efficient - you have plain overall view on all of your habits. And Google Sheet is every time available for free )
And you have a nice voice )
Hi! You're so sweet! Thank you so much for taking the time to watch and comment!! I'm really happy you found it useful 😊👩🏻💻✨
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
This is great. Feels good to check off each task. Manageable, realistic and attainable. Thank you.
Hi! Thank you so much!! And yeah! It feels awesome to use those checkboxes 😊👩🏻💻✨
My dear lord! I spent my whole afternoon practicing the formulas but I feel so satisfied, thank you so much for this explanation. Quick question, is there a way to create pies to see how the tasks behaved compared to each other? Thank you so much for this content! Greetings from Colombia!
I'm so happy to hear that! Thank you! I don't have a tutorial on graphs yet but I can totally add that to my list 😊👩💻✨
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
Wow amazing tutorial! Thank you for this!! I learned so much about how advanced you can make your sheets now!
I'm so happy you liked it! Thank you for watching and commenting! 😊👩🏻💻✨
Thank you for this video!!! Thank you for all the formulas and the clean up part for it to look so good! I instantly subscribed!
I'm really happy you liked it!! Thank you so much for your comment!! I really appreciate it 😊👩💻✨
This was incredibly easy to follow, I've made mine. Let's see if it works!
Love it. I'm a newbie in spreadsheets. ❤
Thank you so much! I followed along and kept pausing at each step to get my tracker set up. Worked out great!
I'm so happy you followed along! Thank you so much for watching and commenting! 😊👩💻✨
very good tutorial and full of information thanks for your information share with us
Thanks you so much, now i know few things about sheets ❤
WOW! This was a phenomenal video. Please keep them coming!
Thank you so much!!!!! ✨ I definitely will!! 😊 Any requests that I can add to my list? 👩💻
@@thinklikeagirlboss would you do a mood tracker, please? and if possible, could it have like a graph or something visual with colors to see how many days you have been in x mood easily. if it inst possible thank you anyway :)
Hi again! I just realized I skipped this message I'm sorry! I would love to!! I will add it to my list 😊👩💻✨
thank you so much it really help me as a student may god bless you
Thank you so much for this tutorial. This was really help full!!! :)
Fantastic tutorial, very detailed but explained with such simplicity. Thank you
Thank you so much!! I'm really happy you liked it! 😊👩🏻💻
🥰 How useful!! I love u ❤️ thanks for sharing the tutorial and the spreadsheets
Hi!! Thank you so much for watching and commenting!! I really appreciate it!! 😊👩💻✨
Thank you so much, Sis for this amazing tutorial. Its help me to recognize my habit for next year. Thank you
This was a very useful tutorial. Easy to follow, I learned quite a few things. Thank you!
I'm so glad to hear that! Thank you for commenting! 😊👩💻✨
Very nice tutorial, I start learning google sheet with this amazing channel. Thank you very much
I'm so happy to hear that! Thank you for watching! 😊👩🏻💻✨
This is so useful, you are a very good teacher. Thanks❤
Thank you so much!! 😊👩🏻💻✨💕
Wow wow ❤ I can't believe i make it .. thankyou i dont even know before this vedio even p of programming thanks ❤
Thank you for this tutorial. Really learnt a lot with this. The more you know :)
You teach really well. Thank you :)
I find you on tiktok, love u for make this tutorial
Hi! Thank you so much for watching and commenting! 😊👩🏻💻✨
AWESOME AWESOME TUTORIAL. THANK YOU SO MUCH. GREAT INSTRUCTIONS!!!
Thank you!! 😊👩💻✨
Such a good tutorial! I could follow it perfectly.
I'm so happy to hear that!! Thank you for watching and commenting! 😊👩🏻💻✨
Thank you so so much, you are so awesome for giving us such useful information and being so detailed. You’ve helped me so much!
Excatly what I was looking for!!!!!
I'm glad you found it useful!! 😊👩💻✨
This is a really great tutorial, thanks! Gonna try and make a reading spreadsheet myself
Thank you so much!! And that's amazing!! Please keep me posted on how that works out! 😊👩🏻💻✨
Hi, Thanks I have mostly worked with Excel so that was a great video to learn some basic Sheets. I have an issue with dividing by 31 - if you add DAY(EOMONTH(D3,0) it will then divide by the number of day for that month. eg =COUNTIF(D4:AH4,TRUE)/DAY(EOMONTH(D3,0)) will give you a true Percentage.
I Just happen to be working on this in a Leap year so it work for 29day in February. If you want to use conditional formatting to clear the unneeded dates and cheeks Custom formula is =AH3>TO_DATE(EOMONTH(D3,0)) and set text to White & fill to White.
i dont speak English, but I understand everything, gracias
That's awesome! Thank you for watching!! 😊👩💻✨
Great and simple tutorial. I am gonna create one for my own. Thanks a ton.
I'm so glad you liked it! Thank you!! 😊👩💻✨
the best excel tutorial ive seen
That's so nice of you to say! Thank you SO much!! 😊👩💻✨
Wonderful! You are remarkably good at this. Your chanel deserves more subscribes. Thanks for sharing us this super useful havbit tracker template.
Thank you so much for your comment!! I hope I can keep on creating content you enjoy 😊👩💻✨💕
By using AI (Artificial intelligence) all things can be done in few clicks but still I want to learn these things.
They never taught me this in school, nor in college. I always wanted to learn this but too much busy with other assignments & work. So thanks a lot for your hard work. I'm your new subscriber!
Well I still don't know your name but thank you so much, Madam
I have a question please: if I need to go to gym only 3 times in the week, how can I make a percentage that is correct at the end?
New user, thank you so much. Looking forward to learning more :)
Hi! Thank you for watching! If you would like to check out the rest of my free tutorials you can find them linked here: thinklikeagirlboss.com/pages/free-youtube-tutorials 😊👩💻✨
YOU ARE THE BESTTTTTT
Thank you so much for this very helpful tutorial. 😊❤
Thank you for watching! 😊👩🏻💻✨💕
Oh ....Great ......Wonderful video. And thank u, this video help me alot❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤😘😘😘😘😘😘😘😘😘😘😘😘😘😘😘
Thank you for the tutorial, this was awesome
i LOVED this tutorial, thank youuuuu!!
I'm so glad!! Thank you for commenting!! 😊👩💻✨
This is amazing I wish I had found this while I was still in school!
I'm so happy you liked it! Thank you for commenting 😊👩🏻💻✨
Thanks for the template for a habit tracker.
Thank you for watching and commenting! 😊👩🏻💻✨
OMG I LOVED IT!!!!!!!!!!!!!!!!!!!!!!!!!! Thank you soooooo MUCCCH
OMG THANK YOU SO MUCH💕💕💕
Thank you for this! Very informative!!! 🎉❤
Thank you so much for the wonderful tutorial!
I'm so happy you liked it! Thank you so much for watching! 😊👩🏻💻✨
Thank you so much for your video, This is what I was lookin for
Thank you so much, it was really helpful ❤❤
I'm so glad to hear that! Thank you for watching! 😊👩💻✨
What an excellent video. Learnt alot
I'm so happy you found it useful!! Thank you for watching! 😊👩🏻💻✨
Thank you so much, love from the Philippines.