software

Hello,
I need to flag milestone yrs of service for our employees.

I was able to download the hiredates from my crappy system but the date
appears as mm/dd/yyyy. What formula can I use to flag those who have or
will have completed their 10th, 15th, 20th, 25th, 30th (etc...) year of
service between Sept 2005 and Aug 2006.

Your assistance is greatly appreciated.

Thank you
Sus

See www.cpearson.com/excel/datedif.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Suequot; gt; wrote in message
...
gt; Hello,
gt; I need to flag milestone yrs of service for our employees.
gt;
gt; I was able to download the hiredates from my crappy system but the date
gt; appears as mm/dd/yyyy. What formula can I use to flag those who have or
gt; will have completed their 10th, 15th, 20th, 25th, 30th (etc...) year of
gt; service between Sept 2005 and Aug 2006.
gt;
gt; Your assistance is greatly appreciated.
gt;
gt; Thank you
gt; Sus
Thanks Bob,
But it seems as though the dates that there refer to is listed as dd/mm/yy
standard Excel serial-date format, my problem is that my system generate
mm/dd/yyyy. Is there anyway around this without having to re-enter the dates
manually cause if that's the case it would be faster for me to manually
calculate it.

Sue

quot;Bob Phillipsquot; wrote:

gt; See www.cpearson.com/excel/datedif.htm
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Suequot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt; I need to flag milestone yrs of service for our employees.
gt; gt;
gt; gt; I was able to download the hiredates from my crappy system but the date
gt; gt; appears as mm/dd/yyyy. What formula can I use to flag those who have or
gt; gt; will have completed their 10th, 15th, 20th, 25th, 30th (etc...) year of
gt; gt; service between Sept 2005 and Aug 2006.
gt; gt;
gt; gt; Your assistance is greatly appreciated.
gt; gt;
gt; gt; Thank you
gt; gt; Sus
gt;
gt;
gt;

Is Excel seeing the mm/dd/yyyy as a real date. albeit in US format, or is it
seeing it as text?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Suequot; gt; wrote in message
...
gt; Thanks Bob,
gt; But it seems as though the dates that there refer to is listed as dd/mm/yy
gt; standard Excel serial-date format, my problem is that my system generate
gt; mm/dd/yyyy. Is there anyway around this without having to re-enter the
dates
gt; manually cause if that's the case it would be faster for me to manually
gt; calculate it.
gt;
gt; Sue
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; See www.cpearson.com/excel/datedif.htm
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Suequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hello,
gt; gt; gt; I need to flag milestone yrs of service for our employees.
gt; gt; gt;
gt; gt; gt; I was able to download the hiredates from my crappy system but the
date
gt; gt; gt; appears as mm/dd/yyyy. What formula can I use to flag those who have
or
gt; gt; gt; will have completed their 10th, 15th, 20th, 25th, 30th (etc...) year
of
gt; gt; gt; service between Sept 2005 and Aug 2006.
gt; gt; gt;
gt; gt; gt; Your assistance is greatly appreciated.
gt; gt; gt;
gt; gt; gt; Thank you
gt; gt; gt; Sus
gt; gt;
gt; gt;
gt; gt;
I don't know, I think it's just listed under quot;generalquot; format

quot;Bob Phillipsquot; wrote:

gt; Is Excel seeing the mm/dd/yyyy as a real date. albeit in US format, or is it
gt; seeing it as text?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Suequot; gt; wrote in message
gt; ...
gt; gt; Thanks Bob,
gt; gt; But it seems as though the dates that there refer to is listed as dd/mm/yy
gt; gt; standard Excel serial-date format, my problem is that my system generate
gt; gt; mm/dd/yyyy. Is there anyway around this without having to re-enter the
gt; dates
gt; gt; manually cause if that's the case it would be faster for me to manually
gt; gt; calculate it.
gt; gt;
gt; gt; Sue
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; See www.cpearson.com/excel/datedif.htm
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Suequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Hello,
gt; gt; gt; gt; I need to flag milestone yrs of service for our employees.
gt; gt; gt; gt;
gt; gt; gt; gt; I was able to download the hiredates from my crappy system but the
gt; date
gt; gt; gt; gt; appears as mm/dd/yyyy. What formula can I use to flag those who have
gt; or
gt; gt; gt; gt; will have completed their 10th, 15th, 20th, 25th, 30th (etc...) year
gt; of
gt; gt; gt; gt; service between Sept 2005 and Aug 2006.
gt; gt; gt; gt;
gt; gt; gt; gt; Your assistance is greatly appreciated.
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you
gt; gt; gt; gt; Sus
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;