Results 1 to 8 of 8

Formula fix (today)-(month/day of hire) for vacation accrual

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2010
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    13

    Formula fix (today)-(month/day of hire) for vacation accrual

    In the attached worksheet, I'm trying to create a formula in Col D that will give me the difference of (Todays) Month/Date and (Date of Hire). The shaded rows at the end do not provide a correct answer. How do I make the Column formula eliminate the 1 (due to hire mnth/day falling between 1/1 and current mnth/day). I've put about 30 hours in this formula, tried it many different ways. . . and realize I just can't get it.

    I'm all for redoing the whole spreadsheet if you have a better way of doing vacation accruals! Hint!
    Thanks for looking at this! I hope to hear from any of you, soon!

    - Daphne
    Last edited by Daphne; 02-10-2010 at 12:10 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1