Format date and time for workdays

Welcome to the Make community!

Yes, that is possible. You’ll need to use various built-in functions:

Screenshot_2025-03-21_090358

e.g.: (paste this into the field and replace the mapped variables)

{{addDays(11.date; ifempty(switch(formatDate(11.date; "ddd"); "Sun"; -2; "Sat"; -1); 0))}} 

This is just an example. Your final solution may or may not look like this depending on your requirements.

For more information, see Date Format links below.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like