Help forumla required to calculate amount of service

s_whitie

Board Regular
Joined
Sep 13, 2007
Messages
96
Hello,

I am trying to calculate the amount of service someone has.

I need 4 different formulas that will tell me:

a. # years and # months
b. # years and # days
c. # months
d. # days

In a. i need to show that 01/01/2007 - 28/02/2007 is 2 whole months ie month start to month end.

Any help would be appreciated

Thanks
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

s_whitie

Board Regular
Joined
Sep 13, 2007
Messages
96
Thanks for the prompt reply

I have played around a little with datedif but it seems to all give me the difference between 2 dates.

I need to calculate whole months, whole days etc

ie if someone joins 01/09/2007 and leaves 31/10/2007 then this would be 2 whole months. Also if someone joins 15/09/2007 and leaves 31/10/2007 this would be 1 month.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,325
Messages
5,595,511
Members
413,995
Latest member
waealu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top