Formula indicating employees entitled to a salary increase every three years from date of appointmen

		Microsoft Office Forums > Microsoft Excel > Excel
Formula indicating employees entitled to a salary increase every three years from date of appointmen

FAQ

Thread Tools

Display Modes

08-07-2018, 12:23 AM

Marcia

Windows 7 32bit Formula indicating employees entitled to a salary increase every three years from date of appointmen

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

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.

« 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
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
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 06:39 AM.