Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 06, 11:27 AM posted to microsoft.public.excel.newusers
Stefi
 
Posts: n/a
Default Years of Service Question?

Hi Kane,

Try this form, it returns 0 while the difference is less than a whole year:
=DATEDIF(D48,TODAY(),"Y")

Regards,
Stefi


„Kane” ezt *rta:

In a form, I have a Years of service note. It works as it should except for
the first year of work, which would really be "0" years for the first year.
D48 02/06/06
D48 is the Anniversary date MM/dd/yy
H48 is the number of years of service
H48 =IF(D48="","",DATEDIF(D48,TODAY(),"Y"))

How can I get this to show "0" years for the first year?

Tks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Slight problem automating Excel in a service someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM
Calculate Years of Service Jerry Excel Worksheet Functions 5 February 24th 05 12:27 AM
Years of service... Kane New Users to Excel 3 January 10th 05 07:11 AM
Help with Years of Service formula.... Wild Bill Excel Discussion (Misc queries) 1 December 6th 04 08:47 PM
Need Formula Help Jan Excel Worksheet Functions 0 November 8th 04 10:49 PM


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017