Hello GTH,
Your current formula is always setting the billing period to the current month based on today's date, rather than aligning it with the actual billing cycle. Try adjusting your formula like this:
Formula:
=IF(DAY(TODAY())>=Summary!I10, DATE(YEAR(TODAY()), MONTH(TODAY()), Summary!I10)...
