Posted to microsoft.public.excel.newusers

Sue

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel dates prior to 01/01/1900	Troy	Excel Discussion (Misc queries)	2	July 14th 06 04:52 PM
Dates in IF statements	ScottEslick	Excel Discussion (Misc queries)	8	January 20th 06 12:49 AM
Find dates in a range; then sum values in that range by a criteria	Anders	Excel Discussion (Misc queries)	4	October 21st 05 03:41 PM
if statements & dates?	Lynn	Excel Worksheet Functions	1	September 19th 05 04:19 PM
Concatenating Dates	jadams-bellevue	Excel Worksheet Functions	2	February 24th 05 07:27 PM

All times are GMT +1. The time now is 06:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us