Oct 17, 2005 #1 Starrizzo Technical User Mar 22, 2004 30 0 0 US I want to be able to find out how many months a person has worked. Is there a way in excel to find that out. 10/5/02-12/04/05= ???
I want to be able to find out how many months a person has worked. Is there a way in excel to find that out. 10/5/02-12/04/05= ???
Oct 17, 2005 1 #2 Lilliabeth Technical User Jan 26, 2005 1,190 0 0 US =DATEDIF(A1,NOW(),"M") Upvote 0 Downvote
Oct 17, 2005 #3 S SkipVought Programmer Dec 4, 2001 47,485 7 38 US BUT... ya gotta have REAL DATES! Why do Dates and Times seem to be so much trouble? faq68-5827 Skip, [sub] [red]A palindrome gone wrong?[/red] A man, a plan, a ROOT canal... PULLEMALL![/sub] Upvote 0 Downvote
BUT... ya gotta have REAL DATES! Why do Dates and Times seem to be so much trouble? faq68-5827 Skip, [sub] [red]A palindrome gone wrong?[/red] A man, a plan, a ROOT canal... PULLEMALL![/sub]