I need to calculate the 1st of the month following a date, but not if the date is already the 1st of the month. I was using the formula =DATE(YEAR(B5),MONTH(B5)+1,1)to calculate the next month, but this formula doesn't work when the date is already the first of the month and I don't want the...