SOLVED
Change the date of Specific Days
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
masfouaa
6 - Meteoroid
‎12-08-2021
10:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everybody
I need a formula or tool can select specific day to change them like below statements:
- "if the day is Friday then the date will decrease by 1 day"
- "if the day is Saturday then the date will decrease by 2 days"
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
binuacs
21 - Polaris
‎12-08-2021
10:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Switch(DateTimeFormat([Due Date],"%A"),[Due Date],"Friday",DateTimeAdd([Due Date],-1,"days"),"Saturday",DateTimeAdd([Due Date],-2,"days"))
‎12-08-2021
11:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Incredible!
thanks a lot.. ^^
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)