Calculate previous week from a predefined period

Ask a Question

Hello,

i need your support.

I have to calculate values of the previous week from a period that the user can define. (ex.1 Month, 1 week, 2 weeks or from day x to day y)

The calendar is built on this format date YYYYMMDD

I made this formula LastWeek = (PeriodTime Variable) - 7

It works if user takes as reference a day of 2nd, 3rd, 4rd week. The problem is when i select day/s from the 1rst week.

Here some screen --> selected period

In the previous week formula

Changing month, format goes to week format. Why?

0 Replies