LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default DatedIF

I'm currently using DatedIf to determine the number of years and months of
service for our employees. Though technically it is correct in it's
calculations, I need to tweak it somewhat or find another method. What I'm
finding is that employees hired on the 31st of the month aren't getting
credit for that month's service on months ending on the 30th (since they
don't actually work up to the 31st of the month).

For example, an employee hired 10/31/05 gets credit for 7 months of service
in May 06. In June of 06 there is no 31st to work through, so she still gets
7 months of service. In July, there are 31 days again so she jumps to 9
months. August again sees no change, while September adjusts.

Is there a solution to this? I tried inserting a couple of hidden columns
that would simply look at the difference between "October" and "June" instead
of looking at the actual dates, but I get an error.
 
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
DATEDIF Deborah Excel Worksheet Functions 11 September 12th 07 04:06 PM
DateDif ? nhvwchic Excel Worksheet Functions 3 August 24th 06 08:40 PM
=DATEDIF Excel User001 Excel Worksheet Functions 2 February 3rd 06 04:20 PM
DateDIF Paul Breslin Excel Programming 4 December 24th 05 06:36 PM
DateDif Average? Damn DateDif UTCHELP Excel Worksheet Functions 14 November 17th 05 10:30 AM


All times are GMT +1. The time now is 11:46 PM.

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

About Us

"It's about Microsoft Excel"