Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Month and year formula
Message
From
06/09/2002 09:11:40
Paula Rhodes
Ashley Publications Ltd.
London, United Kingdom
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Month and year formula
Miscellaneous
Thread ID:
00697455
Message ID:
00697455
Views:
66
Dear All,

I have an Excel file (Office 97) containing the starting and leaving dates of all our staff since 96. I would like to be able to add a formula so that I can see how long in months and years each staff member was in the company. Help suggests DAYS360(C2,D2)/360 but this doesn't produce the kind of result I'd like. It gives answers such as 0.82. I would appreciate any help you can give me.

Thanks in advance for your assistance.
Paula
Next
Reply
Map
View

Click here to load this message in the networking platform