Formula needed

A

accessnovice

I need a formula to figure out how many months an employee has worked since
the date of hire. Thank you in advance for your help.
 
S

Sandy Mann

accessnovice said:
I need a formula to figure out how many months an employee has worked since
the date of hire. Thank you in advance for your help.
Click to expand...

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

where A1 holds the hire date.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
A

accessnovice

Thank you so much for your fast response. Truly appreciate it. Have a great
day!
 
S

Sandy Mann

Glad that you got it to work even although I messed up the example. I did
not notice that the top left cell was not A1 from working out a previous
formula.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Display weeks from a Milestone 0
Excel Noob 2
Benefits Eligibility Dates 3
Select records by month 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0

Top