SOLVED*****Beginer questions: creating a formula in an existing table

******SOLVED*******

I apologize if this is the wrong place to ask this question.

I have an existing table, that I am trying to create a formula in.

There are 2 columns, "Hire Date", and "Time in Service".

I would like to make a formula that will automatically calculate & update the "time in service" column, based on the date in the "hire date" column.

Can anyone help with this?

I've tried following online guides, but I guess I'm not as computer savvy as I thought I was.




Thank you for your time,

HM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi and welcome to the forum

If you want to base the "Time in service" off todays date and the Hire Date", then lets say your dates start in A2 downwards, in B2, copied down enter...
=TODAY()-A2

You may need to format the answer to suite your needs (like general?)

Maybe :
=DATEDIF(E3,TODAY(),"Y") &" years, " &DATEDIF(E3,TODAY(),"YM") &" months, " &DATEDIF(E3,TODAY(),"MD") &" days"

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

Having said that...
=IF(DATEDIF(E2,TODAY(),"y")=0,"",DATEDIF(E2,TODAY(),"y")&" years ")&IF(DATEDIF(E2,TODAY(),"ym")=0,"",DATEDIF(E2,TODAY(),"ym")&" months ")&DATEDIF(E2,TODAY(),"md")&" days"

If you have a lot of these to calc, I suggest you put the TODAY() in its own cell, and then reference it. For instance, if you put =TODAY() in E1, then the formula becomes...
=IF(DATEDIF(E2,E1,"y")=0,"",DATEDIF(E2,E1,"y")&" years ")&IF(DATEDIF(E2,E1,"ym")=0,"",DATEDIF(E2,E1,"ym")&" months ")&DATEDIF(E2,E1,"md")&" days"

If you use a different cell, then adjust the reference as needed

No problem. His formula is the same as my 1st 1, except that I added to test for duration less than a year. Also, as I mentioned, if you have a lot of these to do (100's), then using that many TODAY()'s may tend to slow things down, so it may be better to put that in its own cell and then reference it. TODAY() is what's called a volatile function, meaning that, unlike most functions, TODAY() updates every time anything is done to the workbook...every time you hit enter, for instance.

Thanks for the feedback, too

Happy to help.

To mark your question SOLVED, use the thread tools towards the top of the page (I will do it for you this time)