I have a customer that wants to calculate specific dates ever year for reviewing items in a list (uses flex task too).
So an item that's been reviewed on 1/31/19 should roll to the next review on 4/30/19. The 4/30/19 should roll to 7/31/19. And 7/31/19 should roll to 10/31/19. Then, starting over, the 10/31/19 should roll to 1/31/20. You get the idea.
I calculated in Excel the datedif between these dates. See image below:
There should be 92 days between 10/31 and 1/31. This shouldn't change from year to year (unless I live on another planet).
However when I put the Calculate Date in as below (10/31/2019) is sitting in the Next Review Date field it only adds 89 to the Next Review Date and calculates 1/28/2020. That's three days less than what I put into the formula below.
I've tried all sorts of stuff to make the date come out correctly. I've put in 95 days but it still calculates wrong. I've tried 3 months. Still calculates wrong.
Does anyone have any ideas why this might be calculating wrong?