Help me with Dates in Excel

O

Olu Sanusi

i have two columns with is a date colunm, which is the date the users joined
the company, and i will like to work out the second column to be the amount
of moths they havbeen employed by the company uptill now.(Today)

Your reply will be very much appreciated
[email protected]
 
N

Norman Harker

Hi Olu!

Use:

=DATEDIF(A1,TODAY(),"m")

Returns the number of completed months between the date in A1 and
today.

For details of the DATEDIF function see:

Chip Pearson:
http://www.cpearson.com/excel/datedif.htm


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 29th July: Dominican Republic (Father
’s Day), Faroe Islands (Olavsoka Day), Haiti (Maitresse Silverine),
Norway (St. Olav’s Day), Peru (Aymaraes). Observances: Maitresse
Silverine (Voudon).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A

Anon

Olu Sanusi said:
i have two columns with is a date colunm, which is the date the users joined
the company, and i will like to work out the second column to be the amount
of moths they havbeen employed by the company uptill now.(Today)

Your reply will be very much appreciated
[email protected]
Click to expand...

This has problems because months differ in length. However, a short, simple
answer would be this formula, copied down your second column:
=TEXT(TODAY()-A1,"mm")
 
M

Michelle

If you have your dates in correct format by using the
number format menu, then this is easy. You need a column
with the current date in in. Use this formula: =today().
It will keep the date updated. In the column that you
want to put the months employed, use this formula: Cell
with current date - cell with employed date / 12 for
months (the answer without the /12 will give days). For
example if your current column is "B" and your hired
column is "B", the the formula would be =(B12-A12)/12.
Hope this helps
 
O

Olu Sanusi

Thanks..
Excellent
Norman Harker said:
Hi Olu!

Use:

=DATEDIF(A1,TODAY(),"m")

Returns the number of completed months between the date in A1 and
today.

For details of the DATEDIF function see:

Chip Pearson:
http://www.cpearson.com/excel/datedif.htm


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 29th July: Dominican Republic (Father
's Day), Faroe Islands (Olavsoka Day), Haiti (Maitresse Silverine),
Norway (St. Olav's Day), Peru (Aymaraes). Observances: Maitresse
Silverine (Voudon).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Top