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

07-30-2018, 03:02 AM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps select col A range and use the following CF rule

=YEAR(EDATE($B1,3*12))=2019
Format as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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