Hello.
I am trying to create a function for pay raise due dates. I want to have the due date be a year past when they were hired (or last received a raise), but if it falls in the beginning of the month, it returns to the 1st, if it falls in the end of the month it returns the 16th.
Basically my thought is if someone was hired on 1/5/19 in column A, column B would show 1/1/20 and subsiquently if someone was hired on 4/29/18, column B would show 4/16/19.
I have tried a few nested formulas that could bring about this, but none of them have worked. They all come back with errors. The one I most recently tried is:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(IF(A1<=15,"1","16")))
Every time I put in a date in A1, the day comes back 16 (False). My guess is the cell is treating the whole date like a number, so 1/5/18 looks like 42918, which would mean every date would be greater than 15. Am I right in this?
Would people be able to help me with this function?
Thanks.
Bookmarks