Hi Dear Excel Experts!
Hope you guys are doing great and wish you a Happy New Year?
Well, as you already imagine I come here to ask for a little help. The problem is that I am working on a spreadsheet to track vacation for my HR friend.
The problem this spreadsheet will solve is the following:
If an employee started to work on Jan 1st, 2018, after one year so, on Jan 1st, 2019 this person will have 30 free days of vacations.
I got almost everything Ok, but yesterday she asked me if I can add a feature so that the spreadsheet send her a notification by email 15 days before an employee complete the year so that she can plan to find someone else to replace this employee during its vacations.
I was thinking about it since yesterday and still can't see how I can automate this process.
I am thinking about a script that opens the spreadsheet once a day iterate through all the employees (about 20) then check if today's date is equal to the day that each employee will complete one year minus 15 days, and, if the result is true, send the notification. But I don't know how to implement that with code.
Can you guys please send me an example of something similar or do you have a better approach about how to implement this?
Waiting for your replies.
Thanks in advance and take care!
Hope you guys are doing great and wish you a Happy New Year?
Well, as you already imagine I come here to ask for a little help. The problem is that I am working on a spreadsheet to track vacation for my HR friend.
The problem this spreadsheet will solve is the following:
If an employee started to work on Jan 1st, 2018, after one year so, on Jan 1st, 2019 this person will have 30 free days of vacations.
I got almost everything Ok, but yesterday she asked me if I can add a feature so that the spreadsheet send her a notification by email 15 days before an employee complete the year so that she can plan to find someone else to replace this employee during its vacations.
I was thinking about it since yesterday and still can't see how I can automate this process.
I am thinking about a script that opens the spreadsheet once a day iterate through all the employees (about 20) then check if today's date is equal to the day that each employee will complete one year minus 15 days, and, if the result is true, send the notification. But I don't know how to implement that with code.
Can you guys please send me an example of something similar or do you have a better approach about how to implement this?
Waiting for your replies.
Thanks in advance and take care!
