Calculating Years of Service & Summing Data in Excel

  • Thread starter Thread starter candylady11
  • Start date Start date
  • Tags Tags
    Data Excel Years
Click For Summary
To calculate the number of years employees have been working, the TODAY function in Excel can be used effectively. To determine the duration, subtract the employee's start date from the current date provided by the TODAY function. For financial calculations involving 401K amounts, payroll, and healthcare payments, users can utilize Excel functions like SUM to aggregate values from specific cells. The context suggests that Microsoft Excel is the program being referenced for these calculations.
candylady11
Messages
1
Reaction score
0
Here is the part that I am confused on. I have to calculate the number of years the employees have been working for us, I believe the function I need to use is TODAY but it is not working, how can I get that function to work? I also need to figure out how to use the functions when looking at 401K amounts compared to payroll and health care payments. If I want to get the sum of a few cells I would use SUM or TOTAL?
 
Computer science news on Phys.org
What program is one using? MS Excel?
 
Thread 'ChatGPT Examples, Good and Bad'

Thread 'ChatGPT Examples, Good and Bad'

I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...
View full post »

Similar threads

Data transfer from MS Excel to PSPP
  • · Replies 16 ·
Replies
16
Views
4K
Help with Creating An Excel Line Graph
  • · Replies 1 ·
Replies
1
Views
1K
Help with Annoying Stuff on Excel
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
How to CREATE a green triangle in EXCEL
  • · Replies 3 ·
Replies
3
Views
19K
I with an Excell formula I cannot figure out.
  • · Replies 2 ·
Replies
2
Views
3K
Undergrad Filling in Missing Values in a string of data
  • · Replies 7 ·
Replies
7
Views
1K
Projected Cash Flows: Present and Future Worth Calculations
  • · Replies 12 ·
Replies
12
Views
3K
Did Amazon stop trying once they chose E Ink?
  • · Replies 21 ·
Replies
21
Views
3K
Data analysis by guessing, checking and fixing
  • · Replies 5 ·
Replies
5
Views
4K