Formula to Combine Weekend Dates with Monday

Is it possible to add weekend dates together with a Monday date? I am trying to combine sales for Saturday and Sunday to sales for Monday. For example,

Saturday, July 4, 2020 + Sunday, July 5, 2020 + Monday, July 6, 2020 would equal Monday, July 6, 2020.

Date Time

Accepted answers

JosephSerpis

Hi @BrandonS4 I mocked up a workflow let me know what you think. From your question I assumed the date format was "Saturday, July 4, 2020" please let me know if that is not the case?

Dates_01072020.yxmd

All comments

JosephSerpis

Hi @BrandonS4 I mocked up a workflow let me know what you think. From your question I assumed the date format was "Saturday, July 4, 2020" please let me know if that is not the case?

Dates_01072020.yxmd

BrandonS4

This still works great. However, how can I write the formula so the output is two digit month-two digit day-4 digit year??

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335