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

Hi Daphne,

welcome to the forum. The attachment didn't quite make it. Quite understandable, if I calculate the time of day for your time zone
You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

how 'bout this for column D:

=MOD(($C$1-C3)/365.25,1)

it basically takes your column E value and hacks off any number in front of the decimal point.

Now I can go to bed, too!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save