Forum Discussion
Solved
Requesting assistance on a formula
Community, I need some assistance w/ a formula to capture a % in real time as a project progresses. Please see the attached file for details.
Hi Dave,
Perhaps
=INDEX($B$4:$BD$4,0,INT((TODAY()-$B$6)/14)+1)
and attached
Hi Dave,
Perhaps
=INDEX($B$4:$BD$4,0,INT((TODAY()-$B$6)/14)+1)
and attached
Sergei,
It worked like a champ!!! Thanks for your assistance.
Dave, you are welcome