Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statements and Dates
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statements and Dates
See http://www.cpearson.com/excel/datedif.htm
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sue" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statements and Dates
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 "Bob Phillips" wrote: See http://www.cpearson.com/excel/datedif.htm -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sue" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statements and Dates
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) "Sue" wrote in message ... 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 "Bob Phillips" wrote: See http://www.cpearson.com/excel/datedif.htm -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sue" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statements and Dates
I don't know, I think it's just listed under "general" format
"Bob Phillips" wrote: 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) "Sue" wrote in message ... 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 "Bob Phillips" wrote: See http://www.cpearson.com/excel/datedif.htm -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sue" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel dates prior to 01/01/1900 | Excel Discussion (Misc queries) | |||
Dates in IF statements | Excel Discussion (Misc queries) | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
if statements & dates? | Excel Worksheet Functions | |||
Concatenating Dates | Excel Worksheet Functions |