Dear All,Im trying to create a formula where if an someone starts before the 15th of the month then return the 1st of that month. If they start on the 15th or after then return the 1st of the following month.I have created the below nested IF stateme...
Thank you Brian, Greatly appreciated!I tried it without the nested IF statement prior to posting but it didn't work, possibly because of the two different date adds.Your solution above works perfectly.Thanks Again.
