Counting Parent Row for Weeks

L_123

@Paul Newcome I do that all the time. Usually it's because I get sidetracked on the main functionality of the formula rather than the problem.

My suggested formula is a little fancy, in that the formula checks from the current sunday to have the same output as the previous solutions suggested, but if you want to check from the current date to next date you could potentially simplify this further.

=ROUNDUP((Week@row - TODAY()) / 7) + " Weeks Out"

Paul Newcome

@L@123 Both of them are much more simple than my solution. I'm usually pretty good at not overthinking, but being as bus as I have been I was just (as you said) looking at the formula and not the overall problem.

ginamt3

That did the trick! Thank you both.