# How to make an Excel to caculate the number based on a given date and year?

1. ## How to make an Excel to caculate the number based on a given date and year?

Dear Excel Gods,

I run a small business, and my policy is to give an additional vacation to employees every year.

However, since the hired date/year is different for everyone, I realize it won't be fair unless I count their annual increase by the actual date.
So I'd like to make a chart, that automatically calculates the annual increase, which goes up by 1 every time they have reached a whole year, based on the given hired date.

Is there a way to do this?

I know Excel can do A LOT, but I was also wondering if there is a way that somehow I can be notified with formula by some kind of color changing, I don't know, I'd be happy to be able to do just the first thing I asekd.

Thanks!!

2. ## Re: How to make an Excel to caculate the number based on a given date and year?

Perhaps =DATEDIF(A1,TODAY(),"y") where A1 is the hire date ?

3. ## Re: How to make an Excel to caculate the number based on a given date and year?

Hello nutstae -

Can you upload an excel file to view how you need the data?? and also how the data would look like?? This is to be able to create the formulas.
Best regards!!

4. ## Re: How to make an Excel to caculate the number based on a given date and year?

Vacation.xlsx

Thank you!

5. ## Re: How to make an Excel to caculate the number based on a given date and year?

As I suggested in post #2 try =DATEDIF(B3,TODAY(),"y") and pull down as needed

6. ## Re: How to make an Excel to caculate the number based on a given date and year?

Originally Posted by nutstae
The suggestion of Pepe is a very good one. If you don't mind I include in the increasing Year-Month-Day. If you find it useful, feel free to use it much as you like.

Best Regards and please a have great day.
(Saludos cordiales y que tangas un gran día)

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

#### 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