Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-30-2018, 12:58 AM
Marcia's Avatar
Marcia Marcia is offline Formula indicating employees entitled to a salary increase every three years from date of appointmen Windows 7 32bit Formula indicating employees entitled to a salary increase every three years from date of appointmen Office 2007
Expert
Formula indicating employees entitled to a salary increase every three years from date of appointmen
 
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Formula indicating employees entitled to a salary increase every three years from date of appointmen

There is an agency policy that every 3 years from the date of appointment or promotion, an employee is entitled to a percentage increase in his/her salary. If I use conditional formatting, what is the formula that will mark all employees that will receive increases during the year 2019? Say, Col A contains the names of all employees and column B contains the date of their appointment.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for looking at 1 cell with a date and then comparing it to four date ranges LearningMom Excel 3 10-27-2017 12:44 PM
Formula indicating employees entitled to a salary increase every three years from date of appointmen Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date mshu31 Word 1 02-09-2017 02:04 PM
Date range mysteriously adding 4 years akatz85 Excel 7 03-25-2014 12:36 PM
VLookup formula Problem (salary plus (commission x sales)) topgear2015 Excel 11 06-05-2013 09:02 PM
Formula indicating employees entitled to a salary increase every three years from date of appointmen Using Field Codes to Calculate 5 years from a Date vandy Word 1 09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:12 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