Hi, I have an Excel sheet containing passport details such as issue and expiry dates. I would like to set a reminder before the expiry date. I have been trying on my own but couldn't get the desired result. Need your help.

Thanks in advance.

From United States, New York
Acknowledge(0)
Amend(0)

Please find attached an email with one or two samples in Excel. I will apply the formula and send it back to you.

Clarification on "Reminder"

Could you clarify what you mean by "Reminder"? Are you requesting the cell colors to be highlighted with specific colors? Please provide details and let me know.

Regards,
Manjay
Malay Gauri Consultants Pvt. Ltd. | www.malaygauri.com

From India, Mumbai
Acknowledge(0)
Amend(0)

Hi, Here it is. update data as per your requirement regards Manjay
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Workman Details.xls (62.5 KB, 3450 views)

Acknowledge(3)
SO
Amend(0)

Dear Mr. Aejaz Please find attached EXCEL FORMULAE for your kind perusal. You may learn and utilize the same based on your requirement. I found this in CITEHR database. With profound regards
From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls EXCEL_Formulae.xls (2.38 MB, 2648 views)

Acknowledge(1)
Amend(0)

You may also considered the attached file. Just put expiry date in respective cells in Passport and Entry Visa column and see the result.
From India, Kolkata
Attached Files (Download Requires Membership)
File Type: xls Passport_Expiry_Reminder.xls (45.5 KB, 1415 views)

Acknowledge(1)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.