Formula to determine a specific date within a month based on date ranges.
I am trying to determine a formula to produce a specific date based on date ranges. So when a date (mm/dd/yy) is entered into a column if it is between the 1-15 day of the month, I want it to populate the 25th of the same month into a column- (mm/25/yy), however, if the date is 16-31 day of the month, I want it to populate the 10th of the next month into the column.
Thanks for any help.
Help Article Resources
Check out the Formula Handbook template!