I have 4 dates in 4 different columns. I need to pull a date that lands in this week.
I have 4 different columns for dates: Phase 1, Phase 2, Phase 3, Phase 4. I am trying to find a formula that can pull any date that falls in the current week and populate that date into a cell. Some fields may have "N/A" in them instead of a date.
Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!