Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2022, 01:58 AM
Marcia's Avatar
Marcia Marcia is offline Calculate total services of an employee by year, month and days Windows 10 Calculate total services of an employee by year, month and days Office 2019
Expert
Calculate total services of an employee by year, month and days
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

You're right Arvi. I added a helper column for the base date of computing the total services. The Last Day of Service remained to avoid confusion as to when an employee's service actually ended.
Thank you.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
appt that occurs every year for 1hr per day for 10 days scadaman29325 Outlook 2 07-13-2021 04:58 AM
Calculate total services of an employee by year, month and days Word field last month not working within year change eduzs Word VBA 4 07-25-2019 04:31 PM
Calculate amount of days per month from a given timerange Yde1203 Excel 3 05-02-2019 08:13 PM
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses sleake Excel Programming 2 04-23-2015 11:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft