show in text format the difference between 2 dates
 

Hi all! I've got the following to get done: I have to calculate for our
employees for how long do the work for the company. The format of the result
should look similar to "X years X months X days". Given that their number is
quite big, I'm thinking to write a function and use it wherever I need such
calculations. Does anyone have any ideas how may I get this done? Your help
is much appreciated.

show in text format the difference between 2 dates
 

Hi catrrmg

Use the following which will return the difference between the twoi dates
where, is this example, B1 is their start date and B3 is the current date.

=DATEDIF(B1,B3,"y") & " years, " & DATEDIF(B1,B3,"ym") & " months, " &
DATEDIF(B1,B3,"md") & " days"

Hope this helps

"catrrmg" wrote:

Hi all! I've got the following to get done: I have to calculate for our
employees for how long do the work for the company. The format of the result
should look similar to "X years X months X days". Given that their number is
quite big, I'm thinking to write a function and use it wherever I need such
calculations. Does anyone have any ideas how may I get this done? Your help
is much appreciated.

show in text format the difference between 2 dates
 

See:

http://www.cpearson.com/excel/datedif.aspx
--
Gary''s Student - gsnu200767


"catrrmg" wrote:

Hi all! I've got the following to get done: I have to calculate for our
employees for how long do the work for the company. The format of the result
should look similar to "X years X months X days". Given that their number is
quite big, I'm thinking to write a function and use it wherever I need such
calculations. Does anyone have any ideas how may I get this done? Your help
is much appreciated.

show in text format the difference between 2 dates
 

thanks a lot. it is really helpful!

"Nigel" wrote:

Hi catrrmg

Use the following which will return the difference between the twoi dates
where, is this example, B1 is their start date and B3 is the current date.

=DATEDIF(B1,B3,"y") & " years, " & DATEDIF(B1,B3,"ym") & " months, " &
DATEDIF(B1,B3,"md") & " days"

Hope this helps

"catrrmg" wrote:

Hi all! I've got the following to get done: I have to calculate for our
employees for how long do the work for the company. The format of the result
should look similar to "X years X months X days". Given that their number is
quite big, I'm thinking to write a function and use it wherever I need such
calculations. Does anyone have any ideas how may I get this done? Your help
is much appreciated.