Hi Dave,
Thank you.
I was actually writing it on paper. So it looked like this - today is 11/18/17 and if I am going to round that using 7 then it would look like the example in the help file for dozen, 12, 24, 36. So I mistakenly thought the date would look like, 7, 14, 21, 28. I did not remember to consider that the number for the date 11/18/17 is 2458076. So using round(2458076,7) the result is 2458078 and with datepattern(2458078,“MM/DD/YY”) the result is 11/20/17. The other mistake I made was I assumed round() always rounds down.
It is still not clear to me though how the result of round(2458076,7) is 2458078.
Actually I think I understand. If I divide 2458076 by 7 the result is 351153.714285714285714 so the round() function will look for the next evenly divisible value, in this case it increases the number to 2458078 which when divided by 7 = 351154.
Am I correct?
One more quick question, what criteria does round() use to decide when to round up versus rounding down?