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?
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.
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
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 ?
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?
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.
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.
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.?
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 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