Reference a date in a non date column

Kyle Keever

Hi SS peeps,

I am trying to reference a date in a text column by using the date function but it's not working.

=SUMIFS({Employee 1}, {Employee Date of Sep}, >[Jan 5th]45, {Title}, {Lead Sider})

I've tried using

=SUMIFS({Employee 1}, {Employee Date of Sep}, >Date([Jan 5th]45), {Title}, {Lead Sider})

I'm basically wanting to drag the formula across the row and have the date reference update.

Thanks in advance!

Kyle

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Kyle Keever

This formula will convert your text string into a usable format. Depending on your global region, you may need to use the semi-colon vs the comma I have shown.

=SUMIFS({Employee 1}, {Employee Date of Sep}, DATE(VALUE(LEFT([Jan 5th]@row, 4)), VALUE(MID([Jan 5th]@row, 6, 2)), VALUE(RIGHT([Jan 5th]@row, 2))), {Title}, {Lead Sider})

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @Kyle Keever

This formula will convert your text string into a usable format. Depending on your global region, you may need to use the semi-colon vs the comma I have shown.

=SUMIFS({Employee 1}, {Employee Date of Sep}, DATE(VALUE(LEFT([Jan 5th]@row, 4)), VALUE(MID([Jan 5th]@row, 6, 2)), VALUE(RIGHT([Jan 5th]@row, 2))), {Title}, {Lead Sider})

Will this work for you?

Kelly

Kyle Keever

This works Kelly! Thank you so much!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.