No video :(

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

Подписаться 105 тыс.

Просмотров 193 тыс.

50% 1

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

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 55

@Mahbub_L 3 года назад

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.

@IvanCortinas_ES 3 года назад

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

@user-gw3qj9en7o Месяц назад

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

@John-Titan 11 месяцев назад

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

@user-ry9qn8zt6x 6 месяцев назад

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 6 месяцев назад

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?

@teamxovec 2 года назад

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

@jenpen10j 2 месяца назад

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?

@jenpen10j 3 месяца назад

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

@TareqAhmed072 2 года назад

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

@vaidehiambavale9760 3 года назад

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

@louisepeedell7111 Год назад

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

@MyDearFriend 6 месяцев назад

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

@youssifheshmat4212 Год назад

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

@DJDuncanDesigns 10 месяцев назад

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?

@TheBlessedRed 7 месяцев назад

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 4 месяца назад

Yes pls share your updates here. Thank you in advance

@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 10 месяцев назад

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

@SimonChester-xj5iu Год назад

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

@freidy22 8 месяцев назад

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

@chaddrose8182 Год назад

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

@amymcmacken6045 2 года назад

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.

@lestat77uk 2 года назад

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

@MohAboAbdo 10 месяцев назад

Thank you so much Sir

@SergioMartinez-uk8kt 2 года назад

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

@oupaswoodshop1325 Год назад

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

@anilkumark123 2 года назад

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

@CoolobiTj 3 года назад

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!

@BenDieselBasicAutomotive Год назад

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

@ketransfer2971 2 года назад

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?

@patrickschardt7724 3 года назад

This has a little bit of everything. Nice work

@pinballwizard79 2 года назад

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

@CTTH100 2 года назад

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!

@fmi-immobilier 2 года назад

Great and useful explainations ! Thank you !

@mar25947 2 года назад

This is a Fantastic video! Thanks!

@aislingloughlin8898 5 месяцев назад

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

@ChesterTugwell 5 месяцев назад

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

@vasilikikladouchou6772 2 года назад

Great video and very well explained! Thank you Chester.

@Teambct09 2 года назад

This was incredibly helpful. Thank you!

@boobilegeorge Год назад

Very helpful

@sininv1 3 года назад

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

@christopheropara2057 6 месяцев назад

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

@haritiwari4629 3 года назад

Nice explanation...

@tylerdement3283 2 года назад

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?

@michelleannetruita7045 2 года назад

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

@truthwisdom 2 года назад

Thank you Brother!!

@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 10 месяцев назад

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