Man thanks for this, you are the best. Your video helped to fix the best document for our maintenance team to not forget all service days in our production.
Thank you so much. U make it more easier to understand! I have very limited knowledge with excel since i rarely use before. Done Subscribing your channel. Will refer to your channel to explore more about excel.
Thank you so much. Is there any possibility if this workbook is in CLOSED mode and it'll send email reminder to the user when a product delivery date about to expire?
Great video. This is getting me closer to what I’m looking for. In this example that you’ve created, is there a ways to calculate the remaining days excluding weekends and/or holidays?
Great video but at/around 7:41 seconds, I do not know if it just my computer but it is hard to clearly see the formula written in the formula bar. It would be great if that could be copied/pasted - it is the part showing the nested if
Thankss for this video learned a lot. However I have a question if how do you make an excel formula to know the expiration of the items you bought 2-3 months and then you want to monitor their expiration lets say 6 months expiration from the month you bought the items.?
Thanks for that video - it is useful. My question is is Today automatically updated - for example -if I open the file tomorrow - is it going to present tomorrow's date automatically without doing anything on that filed?
this is a great video, a couple of questions, let's say, once you get the 3 day warning, how can i have excel notify me via outlook? also, how can I send a reminder to several or many people that they need to send out the invoices (in this case) for the ones that have the 3 day warning only? thanks very much in advance!
Hello, I have a list of product, those have different different expire dates. I want my product status cell will be red color after a certain product has expired. Which formula should i use in conditional formatting?
How can I set an alert to notify me (via pop-up message) when I open an excel file on: The day before the 3rd Friday of March, June, Sept and Dec of any particular year ?
Hi there! How can we insert a row with data after each row as I need to do it manually and print it with Emplyee name, DOJ, Salary for each and every employee. It takes lot of time to copy n paste same row for each employee. Pls help.
Hello bro, this is very useful and it definitely very helpful for work. You're good! But next thing, after having all the dates, when i used MATCH function to search for a particular date to filter, I cannot do so as the date cells which were calculated with the formula is "packed" with formulas and i think excel MATCH function cannot recognise the value inside to return... are you able to assist pls? Thanks.
Sir, I simply say Thanks though I could not follow you. It is difficult to see your display as you have not made the screen 'bigger' like all others YT videos. Need reproduce in zoomed screen please.
thumb up for the tutorial, but to join you, you would have to learn how to zoom your tutorial - think about you viewers man, after all not everyone has a 20/20 vision and then it becomes a struggle to watch. Some tutorials pay great attention to show, up close the viewer, what they want to convey to them that is kudo for them but this......... Greetings
This video was so easy to follow. I have finally found one that I can easily understand and not get confused.
11:37 Noooo, we're not bored at all! Thank you for NOT skipping any steps (however irrelevant) 😊
This video was so helpful!! I used this to organise my assignments and it works like a charm. thank you!
So easy to follow, you're a great teacher, ty!
Very useful ! Use of pivot tables at the end has given a summary.
This video was very helpful for my internship project. Thank you very much!
I know this is a couple of years old but this helped immensely. Thank you very much.
After watching this video i believe "NOTHING IS IMPOSSIBLE" Thanks a lot it was really helpful for my project ...
Although the quality of the video is not really clear yet I learnt a lot from it.
Thank you very much
Man thanks for this, you are the best. Your video helped to fix the best document for our maintenance team to not forget all service days in our production.
Thank you so much for you training your so kind and its very easy to understand
You my friend are a life saver. Thanks!!
Great Sir, What a beautiful and detailed explanation, love it. Thanks
Its a wonderful tool, Thank you very much, God Bless You
Thank you for makinf it look so clear and easy!
Thank you so much the video was really helpful and explained it in a very clear and easy way.
Learning step by step, love it , thank you
Your explanation is really good!!! Thank u so much
Thank you so much. U make it more easier to understand! I have very limited knowledge with excel since i rarely use before. Done Subscribing your channel. Will refer to your channel to explore more about excel.
THANK YOU
This Video is very useful. I have try for using this formula for maintaining chemical expiry monitoring. is is fine and working good. Thanks
Thank you! This is so helpful!
Thank you so much. Great Video!
Thank you so much. Is there any possibility if this workbook is in CLOSED mode and it'll send email reminder to the user when a product delivery date about to expire?
Amazing and very easy to understand, Thank u so much...
Amazing video bro. Thanks. Very clear
Very good Explanations.. Thanks
Great job.Thank you
dude thanks so much!! I am doing a work report and this is exactly what I needed! thank you so much, very clear instructions! Subscribed
amazing!!!!!!!!!!! best tutorial ever!!!
AMAZING VIDEO! Thank you so much for helping. Clear and step by step instructions :)
Superb!!! You have made my life easy.
Subscribed 👍
thanks a lot
Thanks
it is very useful for me. thank you so much.
Good Formula. However would appreciate if you explain using zoom , as at some points can't figure out.
Thank you very much, helped me a lot.
Thanks a ton man...🤗 Its a great help 💐
Great video. This is getting me closer to what I’m looking for. In this example that you’ve created, is there a ways to calculate the remaining days excluding weekends and/or holidays?
Cool video. Thanks.
Well Done Sir.
Thank you very much
Useful video
Thanks…It was helpful
A great presentation
Thank you!
Thanks helped me a lot
Great video but at/around 7:41 seconds, I do not know if it just my computer but it is hard to clearly see the formula written in the formula bar. It would be great if that could be copied/pasted - it is the part showing the nested if
thanks a lot...Thant's helped me to much
Superb sir
after charging the warning date the 'about to expire' it is not change to expire. How it happen? Formulas and every thing is ok
this was very useful
is todays date update automatically day by day?
Best video!!!!!!!!!!
Thank you
Thankss for this video learned a lot. However I have a question if how do you make an excel formula to know the expiration of the items you bought 2-3 months and then you want to monitor their expiration lets say 6 months expiration from the month you bought the items.?
Thanks for that video - it is useful. My question is is Today automatically updated - for example -if I open the file tomorrow - is it going to present tomorrow's date automatically without doing anything on that filed?
super duper thank you so much :)
i like it, really helpful however its not clear enough to see.
So clear and the explanation is also on point, thanks a lot.
This is very helpful! You got my like and sucsribe.
it was useful thank you
THANK S BROTHER
you are the best
Can it give me notification reminder
Hi. Will this work on Google Sheets?
this is a great video, a couple of questions, let's say, once you get the 3 day warning, how can i have excel notify me via outlook? also, how can I send a reminder to several or many people that they need to send out the invoices (in this case) for the ones that have the 3 day warning only? thanks very much in advance!
Hello, I have a list of product, those have different different expire dates. I want my product status cell will be red color after a certain product has expired. Which formula should i use in conditional formatting?
wonderful
thanks
How can I set an alert to notify me (via pop-up message) when I open an excel file on:
The day before the 3rd Friday of March, June, Sept and Dec of any particular year ?
how would you do a start dates that may be different then each other and a end date that is different then each other?
question ........does the today date change with the actual date per day???
Please help I’m trying to add a 4th option “Completed” but I’m receiving an error… I do not want all to show expired.
Hi there!
How can we insert a row with data after each row as I need to do it manually and print it with Emplyee name, DOJ, Salary for each and every employee. It takes lot of time to copy n paste same row for each employee.
Pls help.
Thank you ! Can we do that in power bi ?
can i connect this to a calendar? (with the list of my due assignments). btw thanks! great vid
Im trying to set it up so when i enter a date.....i have a warning at 330 days ( yellow) and another warning at 360 days( red). How do i set that up?
Hello bro, this is very useful and it definitely very helpful for work. You're good! But next thing, after having all the dates, when i used MATCH function to search for a particular date to filter, I cannot do so as the date cells which were calculated with the formula is "packed" with formulas and i think excel MATCH function cannot recognise the value inside to return... are you able to assist pls? Thanks.
Could i change the conditional formatting with icon set ? Could you demonstrate it please ?
Could you add a nested if to ignore blank cells?
For example:
=ALS(G7
Great ...how to send email alerts before expiry let's say before 15 days to my email saying this is going to expire soon...THANK YOU
Sir, I simply say Thanks though I could not follow you. It is difficult to see your display as you have not made the screen 'bigger' like all others YT videos. Need reproduce in zoomed screen please.
thumb up for the tutorial, but to join you, you would have to learn how to zoom your tutorial - think about you viewers man, after all not everyone has a 20/20 vision and then it becomes a struggle to watch. Some tutorials pay great attention to show, up close the viewer, what they want to convey to them that is kudo for them but this......... Greetings
Expand please next time struggling to see it
I couldn't see
Its good explanation but the material is not readable.
Hii, Thank you for this video, can you help me how i can receive and email in gmail once the value got About to expire ?
I understood without understanding teeheehee
This video not clear
For 2:01 days remaining i get 01/01/1990 help guys
I cant see what he’s writing 😅
Your video is not to watching
Very poor video quality, hardly can see anything. Improve the video quality that we can see clearly. Otherwise good explanation
Thank you!