+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    CA, US
    MS-Off Ver
    Excel 2007
    Posts
    21

    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. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,128

    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. #3
    Registered User
    Join Date
    06-03-2013
    Location
    Matamoros, Mexico
    MS-Off Ver
    Excel 2007
    Posts
    52

    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!!
    Samuel Cruz
    Matamoros, Mexico.

  4. #4
    Registered User
    Join Date
    07-24-2013
    Location
    CA, US
    MS-Off Ver
    Excel 2007
    Posts
    21

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

    Vacation.xlsx

    Thank you!

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,128

    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. #6
    Registered User
    Join Date
    06-03-2013
    Location
    Matamoros, Mexico
    MS-Off Ver
    Excel 2007
    Posts
    52

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

    Quote Originally Posted by nutstae View Post
    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)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Caculate number of weeks stock
    By dreamer1963 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2014, 07:57 AM
  2. How to caculate the number of cells within the same day?
    By williamkai1989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2013, 07:21 AM
  3. Replies: 8
    Last Post: 05-10-2013, 05:37 AM
  4. [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 AM
  5. make a Year to date column
    By Nick in forum Excel General
    Replies: 3
    Last Post: 04-20-2005, 02:06 AM

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