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

Lori Flanigan

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.

Jeff Reisman

@Lori Flanigan Try this:

=[Start Date]@row +""

Adding a blank text value (double quotes) to a numeric or date value converts the cell to text/number.

Lori Flanigan

Perfect! Thank you, Jeff!

Jeff Reisman

@Lori Flanigan Try this:

=[Start Date]@row +""

Adding a blank text value (double quotes) to a numeric or date value converts the cell to text/number.

Lori Flanigan

Perfect! Thank you, Jeff!