Add Dates into Summary Rollup Values as Text

axwestlake

Hi! I have a sheet with a bunch of summary data at the top (which will be used in reports and Control Center). Two of the summary fields I want to capture are project Start Date and project End Date which are based on the start and end dates from the plan. However, my summary fields are text fields instead of date fields so I can't just say =Start17 (column is Start and row is 17).

After reading a bunch of posts, it looks like I can do =Start17 + "" to essentially add something to the end of the date. That's work except that my dates now appear as 03/08/24 8:00 AM.

I don't want the time portion. Is there a way to pull the date into a text field and have it display as only the date (no time)?

Jason Tarpinian

Try using the DATEONLY() function. Would look like:

=DATEONLY(Start17) + ""

SmartWay360

Hi,

You can try to use DATEONLY function.

Best,

Beata

Jason Tarpinian

Try using the DATEONLY() function. Would look like:

=DATEONLY(Start17) + ""

SmartWay360

Hi,

You can try to use DATEONLY function.

Best,

Beata