Due Date Pop-up Alert in Excel | Date Due Tracker - Formula & Due Date Color Change Notifications
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- Download the featured workbook here: www.bluepecant...
In this video I demonstrate three methods for tracking due dates.
1) Use a formula to display an in cell alert using the IF, AND and TODAY functions
2) Apply conditional formatting using a formula
3) Create a VBA pop-up alert that automatically appears when the workbook is opened
Need pre-built Excel spreadsheet solutions? Try Simple Sheets - over 100 templates covering your personal and work-based needs including Gantt charts, personal budgets, employee scheduling, timesheets and more… www.simpleshee...
By clicking on this link you are helping to support this blog - thanks!
------------------------ - แนวปฏิบัติและการใช้ชีวิต
![[UNCUT] “บอสณวัฒน์” ลากไส้!! ใครหนุนหลัง "แม่ตั๊ก ป๋าเบียร์" I คนดังนั่งเคลียร์ I 30 ก.ย. 67](http://i.ytimg.com/vi/QlD7mU2KKRk/mqdefault.jpg)
It's really cool. But is it possible when this workbook is in CLOSED mode at least a reminder email to send to the user of this file? So he'll open and send reminder to the customer if needed? Because an user may not open the workbook every day for such reason need this email reminder to user.
How can I set a remind or a pop for the expiry date so for example 11/06/2022 so it would come up with a pop up on the day or 1 day before
This is a great tutorial, thank you. How can you stop the VBA based on text in another cell?
Could you update the spreadsheet to include a column which includes the “date paid”. Then would you mind updating the formula so that if the “date paid” cell is blank or there is a date which is on or before the “date due” then a reminder is not created? Thanks.
is it possible to have this send email reminders for each person responsible for each task due for example if some tasks where completed by me and some where completed by someone else? Kind of combining the 2 of your videos together (other one was titled: VBA to Automate Sending Email From Excel Table)
My goal is for it to send one email per task expired to the correct person responsible for that task.
Anyways thanks for the amazing vids I never knew could do so much with excel this is really fascinating stuff!!
this is great, but how to you display commas between numbers in NotificationMsg string?
I implemented all this and it works brilliantly, however, once I have closed or completed my data from the alert, how do I stop it coming up as needing chasing as it still thinks it is there even if it isn't?
Could you please share a video on how to add pop up reminder with date and time.
Excellent! Is it possible to run VBA not only for H2 but for each task? Because for some tasks "Bring Forward Reminder (days)" varies. In some tasks reminder should pop-up before 2 days for others 5, 10, 20 days.
Thanks again!
mine is showing VALUE! error, how do i correct that?
Thank you for the tutorial it helped me with my workbook.
How can I remove the invoice from being included in the notification when the invoice has been paid?
Hi Chester, I cant seem to see the VBA code in the description box. Has it been deleted? Thank you
Hi, you can get it following this link www.bluepecantraining.com/due-date-pop-up-alert-in-excel/ Apologies for any confusion.
Good morning Chester, Thank you for the video it has been so helpful for me but I was wondering if you could show me how to take column B and D and move it to a new tab to show a quick summary of upcoming and current due dates.
NEED CODE...
The use of conditional formatting with dates is always very useful. Excellent resolution with the macro. Thank you for this example Chester!
Really great video, clear and concise... it helped me a lot... thank you so much
Very Helpful video❤
Can you please tell me how to write the script (Codes) for Google sheets, not Excel?
Thank you in advance
great video! I need to expand on this, do you offer one on one services?
Thank you for the video, it's was very useful. It made my job easy to Following the Payment
Thank you so much! That was brilliant and I learnt so much.
Omg the vba is amazing just done my first one following this and impressed myself thank you
Thanks for the video. Can you advise the code modification to break the results (INV1 INV3 INV4) displayed in the notification box on separate lines instead of inline? Thanks!
Hello, even when I download the file and copy the code in, I am still not getting notified. Can you help me out with this?
How do you rest the reminder for each month if this was a bill payment
Thanks for the learning.... more power to you..
This is great. Thanks! Is it also possible to have this in hours instead of days? For instance, a pop-up 2 hours before a given time in a cell?
Thank you! Exactly what I needed to make some progress.
Thanks a lot! It is exactly what I've been trying to find since a very long time 😃👍
Great video really helped me but i could not find the code has is been removed
Just discovered this today! Fantastic! Hope someone can answer a question: How would I be able to do this for multiple due dates? e.g., we have a day after date, a week after follow up date and a report due date.
UPDATE: I figured that part out. How do I get the display box to separate what is displayed by commas? For example, it says "...is due" Inv 1 Inv2 Inv 3. How would I get it to put commas and a space between each one?
Do you mind sharing your solution for the multiple due dates?
Basically I have a leave tracker and I need to track each individual return date (obviously not all will begin on the same date).
That's one function I really need at this point.
Yes pls share your updates here. Thank you in advance
hi I like to check for the BV. you set the row, is there a way for the row range to be auto as it add on? thanks
very useful, and thorough, it helps me a lot.
A question: how can be done the alerts coding if the information is in different sheets, i.e. a set of companies in different sheets, which the relevant information is showing in a summary page, depending of the drop down (i took it from other of your amazing videos).
Can I use this in Google Sheet? Btw, this really helpful
I am really grateful for this video. It helped me to learn myself and applied for one of my clients.
What do you do if you have several due dates on one sheet? Make a set a reminder column for each due date ie 2 month, 1 year, 2year, 3year etc
use this formula: =IF(OR(AND(C2"", TODAY()+$M$1>=C2), AND(D2"", TODAY()+$M$1>=D2), AND(E2"", TODAY()+$M$1>=E2), AND(F2"", TODAY()+$M$1>=F2), AND(G2"", TODAY()+$M$1>=G2)), "Yes", "") this is for 5 columns, adjust the cells and formula according to your spreadsheet
Great and useful explainations ! Thank you !
This is a Fantastic video! Thanks!
This was incredibly helpful. Thank you!
Thank you so much Sir
I have problem with the date due
This has a little bit of everything. Nice work
Great video and very well explained! Thank you Chester.
Thank you Brother!!
Hi thank you, this was really useful! How do I make the alert exclude weekends? Cuz I would only want the alerts to consider weekdays/working days when tabulating the alert.🤔
Hey jason, did u find a solution to ur question is yes, kindly share it across
@@divijm641 Form Office 2007 "=WORKDAY(start_date; days; [holidays])"
"start_date" can be a date, a cell with a date or TODAY();
"days" is a number positive for the future or negative for the past;
"[holidays]" cells with holidays dates to skip when counting. It's optional.
Thank you soo much
Nice explanation...
Thanx
This was awesome! Just what I needed. Thank you so much
Very helpful