# Format date and time for workdays **URL:** \ **Category:** Questions\ **Tags:** functions\ **Created:** [March 19, 2025, 4:42pm UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747 "2025-03-19T16:42:01Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![m\_m](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@m\_m](https://community.make.com/u/m_m)\ **Post date:** [March 19, 2025, 4:42pm UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747/1 "2025-03-19T16:42:01Z")
Hi folks, I’m currently looking for a solution for the following case. I want to set a reminder for a call, so that an employee gets this reminder in his google calender 24 hours before the call starts. For this I have to use the “date and time functions” and say “addHours(Call-Date; -24)”. How can I make sure, that this function also takes into account the working days? In Germany, normal employees only work from monday-friday. I want to avoid, that if the call-date is on monday, the employee gets the reminder on sunday. In This case, the reminder should be set to friday. Can somebody help? Thanks! ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/1/911351959b5275696971687650f5dfb08a3715d9.png) ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [March 19, 2025, 5:17pm UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747/2 "2025-03-19T17:17:34Z")
Hi @m_m Please try below formula and replace {{now}} with your actual variable {{if(formatDate(addHours(now; -24); “MMMM”) = “Sunday”; addHours(now; -72); addHours(now; -24))}} **Regards,** _Msquare Automation - Platinum Partner of Make_ @Msquare_Automation ---
**Author:** ![m\_m](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@m\_m](https://community.make.com/u/m_m)\ **Post date:** [March 20, 2025, 11:45am UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747/3 "2025-03-20T11:45:25Z")
Hi, thanks for your help. This formulare doesn’t work. Can you explain the formular for me briefly? Edit: replace “MMMM” with “dddd” ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [March 21, 2025, 1:36am UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747/4 "2025-03-21T01:36:30Z")
Welcome to the Make community! Yes, that is possible. You’ll need to use various built-in functions: ![Screenshot_2025-03-21_090358](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/5/753654a8d0ffef768c6410de512bcb5e21ff882f.png) e.g.: _(paste this into the field and replace the mapped variables)_ ```plaintext {{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](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual” - [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified ### Help Centre Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want - [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [March 21, 2025, 1:41am UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747/5 "2025-03-21T01:41:49Z")
# Demo I have created a demo for you to try it out! ![Screenshot_2025-03-21_090313](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/f/af8820988966256870de35d5930ec0fe2c26b871.png) **Example Dates** ![Screenshot_2025-03-21_090325](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/3/a370f2b776055b1ef75009c9c24f075aff9df531.png) **Output** ![Screenshot_2025-03-21_090315](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/e/0e46f25d74ac4a0b7e2b45af249c11648ac5c51e.png) ## Module Export - quick import into your scenario You can **copy** and **paste** this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above. 1. Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the **right** of the code, which looks like this: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/8/c84e1e230dccfa07b6d6d27e2c0fecf7dc7a5c32.png) 2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (the paste keyboard shortcut for Windows) to paste directly in the editor. 3. Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections. **JSON module export below** — paste this directly in your scenario editor ```json {"subflows":[{"flow":[{"id":184,"module":"util:SetVariables","version":1,"parameters":{},"mapper":{"variables":[{"name":"date_on_wednesday","value":"{{setDay(now; \"Wednesday\")}}"},{"name":"date_on_saturday","value":"{{setDay(now; \"Saturday\")}}"},{"name":"date_on_sunday","value":"{{setDay(now; \"Sunday\")}}"}],"scope":"roundtrip"},"metadata":{"designer":{"x":837,"y":265,"name":"Example Dates"}}},{"id":185,"module":"util:SetVariables","version":1,"parameters":{},"mapper":{"variables":[{"name":"new_wed_date","value":"{{addDays(184.date_on_wednesday; ifempty(switch(formatDate(184.date_on_wednesday; \"ddd\"); \"Sun\"; -2; \"Sat\"; -1); 0))}}"},{"name":"new_sat_date","value":"{{addDays(184.date_on_saturday; ifempty(switch(formatDate(184.date_on_saturday; \"ddd\"); \"Sun\"; -2; \"Sat\"; -1); 0))}}"},{"name":"new_sun_date","value":"{{addDays(184.date_on_sunday; ifempty(switch(formatDate(184.date_on_sunday; \"ddd\"); \"Sun\"; -2; \"Sat\"; -1); 0))}}"}],"scope":"roundtrip"},"metadata":{"designer":{"x":1082,"y":267,"name":"Avoid Weekends!"}}}]}],"metadata":{"version":1}} ``` _Note: Did you know you can reduce the size of blueprints and module export code like the above, using the [Make Blueprint Scrubber](https://community.make.com/t/free-tool-reduce-blueprint-module-export-by-removing-extra-details/50697)?_ Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [April 8, 2025, 5:31pm UTC](https://community.make.com/t/format-date-and-time-for-workdays/75747/6 "2025-04-08T17:31:42Z")