Formula to convert date (e.g., 03/13/22) to text/number field (03/13/22) in same sheet?

A sheet that has a Dynamic View includes a date field (Start Date) that Dynamic Viewers need to use as a filter. Since users cannot filter by date fields in Dynamic View, I've added a helper column (text/number) in the sheet but cannot find a formula to pull the dates in the Start Date column into the helper column so Dynamic Viewers can use that field to filter.

Thanks for your help!

Lori F.

Tags:

Best Answers

Answers