I have two columns that I have a report date (AL) and end date (BA). I am using DATEDIF to calculate the number of days in between.
I also want to use those days to convert to how many days of leave acquired. For instance, if the number of days is 1-6 they would acquire .5 days, 7-12 equals 1 day, 13-18 equals 1.5 days, 19-24 equals 2 days, etc.
Is there a way to do all of this within the same column?
I also want to use those days to convert to how many days of leave acquired. For instance, if the number of days is 1-6 they would acquire .5 days, 7-12 equals 1 day, 13-18 equals 1.5 days, 19-24 equals 2 days, etc.
Is there a way to do all of this within the same column?