S
sababu
what is the best option in excel to create a program that reminds of
passport renewals
passport renewals
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JMay
Create a data table of your data (Person's Name, Address, Position, XPPDate)
Use the Data, Filtering options, either Auto-Filtering (Custom) or
Advanced-Filtering. These Should do it
Use the Data, Filtering options, either Auto-Filtering (Custom) or
Advanced-Filtering. These Should do it
U
Upula Prematunga
You may use conditional formatting in the passport renewal date. for example
it could highlight the passports due for renewal within the ,say, next 30
days, with the following conditional formula:
Assuming cell column c contains renewal dates and cell c2 is one of them :
Formats/conditional Formatting/Formula is/ =c2-today()<=30
Select required fhighlight format from the Formats (eg Red/bold etc)
Then use format painter to copy cell c2 format right down the C column.
Hope bthis helps.
:
it could highlight the passports due for renewal within the ,say, next 30
days, with the following conditional formula:
Assuming cell column c contains renewal dates and cell c2 is one of them :
Formats/conditional Formatting/Formula is/ =c2-today()<=30
Select required fhighlight format from the Formats (eg Red/bold etc)
Then use format painter to copy cell c2 format right down the C column.
Hope bthis helps.
:
A
Andy Brown
You could combine DATEDIF function with Conditional Formatting.
If for example a passport lasts ten years and you want to be reminded 2
months before it expires. With an issue date of 26th November 1993 in A1, go
to Format -- Conditional Formatting.
Set Condtion1 to Formula Is. In the text box, enter
=DATEDIF(A1,TODAY(),"m")>117
(10 years = 120 months, so you want to know when it hits 118 months).
Click the Format button, select the Number tab, pick a colour and click OK.
Click OK again.
Now amend the date in A1 to 25th November 2003.
You can use the Format Painter tool to apply the conditional formatting to
other cells.
HTH,
Andy
If for example a passport lasts ten years and you want to be reminded 2
months before it expires. With an issue date of 26th November 1993 in A1, go
to Format -- Conditional Formatting.
Set Condtion1 to Formula Is. In the text box, enter
=DATEDIF(A1,TODAY(),"m")>117
(10 years = 120 months, so you want to know when it hits 118 months).
Click the Format button, select the Number tab, pick a colour and click OK.
Click OK again.
Now amend the date in A1 to 25th November 2003.
You can use the Format Painter tool to apply the conditional formatting to
other cells.
HTH,
Andy