Due Date Pop-up Alert in Excel | Date Due Tracker - Formula & Due Date Color Change Notifications

[@IvanCortinas_ES]

The use of conditional formatting with dates is always very useful. Excellent resolution with the macro. Thank you for this example Chester!

[@John-Titan]

This is a great tutorial, thank you. How can you stop the VBA based on text in another cell?

[@TareqAhmed072]

I am really grateful for this video. It helped me to learn myself and applied for one of my clients.

[@JenniferBentley-r5j]

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.

[@willbe515sara]

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?

[@louisepeedell7111]

Omg the vba is amazing just done my first one following this and impressed myself thank you

[@Bill-c4w6v]

Hi Tugwell, I have used your excel as a template for my pop up reminder. I would like to know if I can have 1 invoice per line instead of them clustering in one line.

[@jenpen10j]

Thank you so much! That was brilliant and I learnt so much.

[@chaddrose8182]

Thank you! Exactly what I needed to make some progress.

[@lestat77uk]

Really great video, clear and concise... it helped me a lot... thank you so much

[@freidy22]

great video! I need to expand on this, do you offer one on one services?

[@Mahbub_L]

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.

[@vasilikikladouchou6772]

Great video and very well explained! Thank you Chester.

[@teamxovec]

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

[@anilkumark123]

Thank you for the video, it's was very useful. It made my job easy to Following the Payment

[@fmi-immobilier]

Great and useful explainations ! Thank you !

[@patrickschardt7724]

This has a little bit of everything. Nice work

[@pinballwizard79]

Thanks a lot! It is exactly what I've been trying to find since a very long time 😃👍

[@Teambct09]

This was incredibly helpful. Thank you!

[@BenDieselBasicAutomotive]

Thanks for the learning.... more power to you..

[@CTTH100]

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!

[@mar25947]

This is a Fantastic video! Thanks!

[@SergioMartinez-uk8kt]

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

[@ketransfer2971]

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?

[@youssifheshmat4212]

Very Helpful video❤ Can you please tell me how to write the script (Codes) for Google sheets, not Excel? Thank you in advance

[@vaidehiambavale9760]

Could you please share a video on how to add pop up reminder with date and time.

[@KateFeldman-q6d]

this is great, but how to you display commas between numbers in NotificationMsg string?

[@MohAboAbdo]

Thank you so much Sir

[@sininv1]

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

[@CoolobiTj]

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!

[@jasonwhatswifme]

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

[@divijm641]

Hey jason, did u find a solution to ur question is yes, kindly share it across

[@EmilioBaldi]

​@@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.

[@reginahardaway7454]

This was awesome! Just what I needed. Thank you so much

[@amymcmacken6045]

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.

[@MyDearFriend]

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!!

[@DJDuncanDesigns]

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?

[@Chopped_and_screwed]

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.

[@Simply_Shey]

Yes pls share your updates here. Thank you in advance

[@jenpen10j]

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?

[@truthwisdom]

Thank you Brother!!

[@haritiwari4629]

Nice explanation...

[@SimonChester-xj5iu]

Great video really helped me but i could not find the code has is been removed

[@oupaswoodshop1325]

How do you rest the reminder for each month if this was a bill payment

[@Ebonypinar]

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

[@FlorinAntonoaei]

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

[@aislingloughlin8898]

Hi Chester, I cant seem to see the VBA code in the description box. Has it been deleted? Thank you

[@ChesterTugwell]

Hi, you can get it following this link www.bluepecantraining.com/due-date-pop-up-alert-in-excel/ Apologies for any confusion.

[@truthlover6511]

Thank you soo much

[@michelleannetruita7045]

Can I use this in Google Sheet? Btw, this really helpful

[@tylerdement3283]

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?

[@alializadeh8195]

Thanx

[@christopheropara2057]

mine is showing VALUE! error, how do i correct that?

[@billyraybalatayo3791]

I have problem with the date due

[@ganesankannan4953]

NEED CODE...