Due Date Pop-up Alert in Excel | Date Due Tracker - Formula & Due Date Color Change Notifications
HTML-код
- Опубликовано: 4 окт 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!
------------------------
The use of conditional formatting with dates is always very useful. Excellent resolution with the macro. Thank you for this example Chester!
Thank you so much! That was brilliant and I learnt so much.
I am really grateful for this video. It helped me to learn myself and applied for one of my clients.
Omg the vba is amazing just done my first one following this and impressed myself thank you
Thank you! Exactly what I needed to make some progress.
This has a little bit of everything. Nice work
Thanks a lot! It is exactly what I've been trying to find since a very long time 😃👍
Thank you for the video, it's was very useful. It made my job easy to Following the Payment
This is a great tutorial, thank you. How can you stop the VBA based on text in another cell?
Really great video, clear and concise... it helped me a lot... thank you so much
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.
This was incredibly helpful. Thank you!
Thanks for the learning.... more power to you..
Great and useful explainations ! Thank you !
Great video and very well explained! Thank you Chester.
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.
This was awesome! Just what I needed. Thank you so much
This is a Fantastic video! Thanks!
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?
Thank you so much Sir
Thank you Brother!!
Nice explanation...
Could you please share a video on how to add pop up reminder with date and time.
Very Helpful video❤
Can you please tell me how to write the script (Codes) for Google sheets, not Excel?
Thank you in advance
this is great, but how to you display commas between numbers in NotificationMsg string?
Thank you soo much
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
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?
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
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?
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).
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!!
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!
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!
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.
Great video really helped me but i could not find the code has is been removed
great video! I need to expand on this, do you offer one on one services?
Can I use this in Google Sheet? Btw, this really helpful
Thanx
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
How do you rest the reminder for each month if this was a bill payment
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.
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
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.
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?
mine is showing VALUE! error, how do i correct that?
NEED CODE...
I have problem with the date due
Very helpful