How to subtract a date from a date ie years/months elapsed

September 16, 2014 at 06:34:10
Specs: Windows 7
I want to calculate how long a member of staff has worked for the company and therefore need to subtract their starting date from the current date.

See More: How to subtract a date from a date ie years/months elapsed

Report •


#1
September 16, 2014 at 06:58:06
If you use google to search:

Time elapsed calculator

There are a few online results to help. I hope they help.

For the fun of it I calculated how long I have been in existence :

2,177.43 total weeks
or: 15,242.00 total days
or: 365,808.00 total hours
or: 21,948,480.00 total minutes
or: 1,316,908,800.00 total seconds

That was from the first result google gave me.

Thank god no one will be able to figure out when I was born.

message edited by btk1w1


Report •

#2
September 16, 2014 at 08:13:58
Thanks will try that. Have tried all the other suggested formula's and for some reason they are not working!

Report •

#3
September 16, 2014 at 14:08:52
Hi JillyCee,

Were you hoping to do this in an Excel spreadsheet?

If so your question would be better addressed in the "Office Software" forum.

The website(s) might serve better to double check the formulas accuracy.

I done a quick google search for the formula and there are plenty of hits:

http://bit.ly/Zou1NV


Report •

Related Solutions

#4
September 17, 2014 at 11:49:32
If you are trying to do this in an Excel worksheet, you should be aware that Excel will sometimes not recognize a date as a date, depending on how the "date" got into the worksheet. Very often, downloads from other applications end up as Text and the Excel Date functions won't work, even if you try to format the cell as a Date.

Can you give us a little more information about your worksheet and the date cells and what you are trying to do?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
September 18, 2014 at 01:57:21
I am trying to subtract an employees start date with the company from todays date to establish their length of employment with the company.

Report •

#6
September 18, 2014 at 04:05:42
Yes, we know that from your first post.

What I would to know is how the dates got into the spreadsheet i.e. manually entered, copied from another source via copy/paste, downloaded from the web or a database, etc.

What format are they in? 9/17/2014, Wednesday September 17, 2014, etc.

What formulas have you tried?

Keep in kind that we can't see your spreadsheet from where we are sitting. In fact, you haven't even told us what application you are using, so maybe it isn't even an Excel spreadsheet. Help us help you by supplying as much as detail as you can.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#7
September 18, 2014 at 06:38:05
I have managed thank you and yes it was an Excel Spreadsheet.

Report •

#8
September 18, 2014 at 06:46:42
I'm glad that you were able to resolve your issue.

Would you care to tell us how you have solved the issue? This is a common question in this forum and we like to save the solutions in the archives.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question