General information
Title:
Month and year formula
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only