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 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
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?
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.?
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.
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?
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?
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.
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 ?
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 helpful!! I used this to organise my assignments and it works like a charm. thank you!
AMAZING VIDEO! Thank you so much for helping. Clear and step by step instructions :)
This video was so easy to follow. I have finally found one that I can easily understand and not get confused.
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
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.
Very useful ! Use of pivot tables at the end has given a summary.
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.
So easy to follow, you're a great teacher, ty!
Learning step by step, love it , thank you
You my friend are a life saver. Thanks!!
Your explanation is really good!!! Thank u so much
Great Sir, What a beautiful and detailed explanation, love it. Thanks
Thank you for makinf it look so clear and easy!
This video was very helpful for my internship project. Thank you very much!
11:37 Noooo, we're not bored at all! Thank you for NOT skipping any steps (however irrelevant) 😊
Although the quality of the video is not really clear yet I learnt a lot from it.
Thank you very much
Thank you! This is so helpful!
Thank you so much the video was really helpful and explained it in a very clear and easy way.
Amazing and very easy to understand, Thank u so much...
After watching this video i believe "NOTHING IS IMPOSSIBLE" Thanks a lot it was really helpful for my project ...
amazing!!!!!!!!!!! best tutorial ever!!!
Thanks a ton man...🤗 Its a great help 💐
Thank you very much, helped me a lot.
Superb!!! You have made my life easy.
Subscribed 👍
Thank you so much for you training your so kind and its very easy to understand
A great presentation
Thank you so much. Great Video!
you are the best
I know this is a couple of years old but this helped immensely. Thank you very much.
super duper thank you so much :)
Its a wonderful tool, Thank you very much, God Bless You
Amazing video bro. Thanks. Very clear
it is very useful for me. thank you so much.
Cool video. Thanks.
So clear and the explanation is also on point, thanks a lot.
Thanks helped me a lot
Great job.Thank you
Very good Explanations.. Thanks
Thank you!
Best video!!!!!!!!!!
it was useful thank you
this was very useful
Thanks…It was helpful
This is very helpful! You got my like and sucsribe.
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 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
Thank you very much
Could i change the conditional formatting with icon set ? Could you demonstrate it please ?
THANK S BROTHER
thanks a lot...Thant's helped me to much
Thank you
THANK YOU
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?
This Video is very useful. I have try for using this formula for maintaining chemical expiry monitoring. is is fine and working good. Thanks
wonderful
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 a lot
Well Done Sir.
Thank you ! Can we do that in power bi ?
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.
Useful video
how would you do a start dates that may be different then each other and a end date that is different then each other?
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!
thanks
Good Formula. However would appreciate if you explain using zoom , as at some points can't figure out.
Superb sir
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?
Thanks
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?
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.
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 ?
can i connect this to a calendar? (with the list of my due assignments). btw thanks! great vid
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.
question ........does the today date change with the actual date per day???
Could you add a nested if to ignore blank cells?
For example:
=ALS(G7
after charging the warning date the 'about to expire' it is not change to expire. How it happen? Formulas and every thing is ok
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?
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
is todays date update automatically day by day?
Hi. Will this work on Google Sheets?
i like it, really helpful however its not clear enough to see.
Can it give me notification reminder
Expand please next time struggling to see it
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.
I couldn't see
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 ?
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
Its good explanation but the material is not readable.
I understood without understanding teeheehee
For 2:01 days remaining i get 01/01/1990 help guys
This video not clear
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!