Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula indicating employees entitled to a salary increase every three years from date of appointmen Formula indicating employees entitled to a salary increase every three years from date of appointmen
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2018, 12:23 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: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you Pecoflyer. I tried your formula but it only applies to those who were appointed in 2016. It should also mark the employees with appointments in 1995, 1998, 2001, 2004, 2007, 2010, 2013.
Reply With Quote
  #2  
Old 08-07-2018, 01:47 AM
xor xor is offline Formula indicating employees entitled to a salary increase every three years from date of appointmen Windows 10 Formula indicating employees entitled to a salary increase every three years from date of appointmen Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Can the attached be used?
Attached Files
File Type: xlsx SalaryIncrease.xlsx (11.9 KB, 15 views)
Reply With Quote
  #3  
Old 08-13-2018, 03:33 PM
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: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Thank you Xor (my apologies for mis-spelling your name earlier). I changed the random dates to the actual appointments of the employees and applied the conditioning formula that you suggested. It was just the very solution that I had been racking my brain to come up with. Again, big thanks.
Reply With Quote
Reply

« Previous Thread | Next Thread »


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 03:57 AM.

Contact Us - Privacy Statement - Top

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