LinkBack URL
About LinkBacks
i have database of employees registered. all of them are foreign, so i want to know if there is a way for a message to pop up 5 days before there visa date expires.
thanks in advance
i have database of employees registered. all of them are foreign, so i want to know if there is a way for a message to pop up 5 days before there visa date expires.
thanks in advance
You mean you want a popup with their names?
then it should have a macro
But the easier one will be to have a table which lists the names of peoples who's visas are gonna expire as mentioned, which can be achieved with the formula and will be easier to maintain if you are not familiar with macros.
Please post a sample file also
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
i have sample file Emplyee sample.xlsx when there is 5 days remaining for the expiry date for each employee, i want the message to pop up
sorry for the late replay
anybody that can help ?
You can use conditional formatting for the same,It will highlight the employee whose Visa will be expiring in 5 days.
i did that, but i want a message to pop up when the conditions are met. if you can give me a code or something that would really be helpful :D
Hi Slytidar,
Use Conditional formatting or you can use this formula of excel :
=IF(AND((C2-TODAY()<=5),(C2-TODAY()>0)),"Less Than 5 Days Remaining","OK")
Pu this formula in D2 cell and drag till end of record. Hope this will help you
thank you
that works too :D. isnt there anyway to get a message popup for the names of expired employees ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks