You can use Conditional Formatting to have the cells..........date and
name cell turn color when 10 days before due date.

A1 contains the date 25.03.12

=A1-TODAY()<11 entered as a formula in CFFormula is:

Or you could have a VBA message box pop up if you wanted to go that
route.


Gord

On Tue, 6 Mar 2012 18:13:32 +0000, Moideen
wrote:


We are maintaining employees passport details in excel, Is there any
function for reminding passport expiry date before 10 days

Example : PP Expiry Date : 25.03.2012,

Need to get reminder on 15.03.12 with employee name

Pls help me..