Lastfullweek

[Former Member]

Morning all,

I am using Last Full Week function in my formula to calculate information for last week however that runs from Sunday to Saturday, instead I would like to run it from Monday to Friday.

Is there any possibility I can do this using Lastfullweek function?

I have tried looking into a help file but it doesn't show any help on this issue.

(Do I have create a formula to make it work?)

Regards

Jehanzeb

[Former Member · Accepted solution]

Hi,

I guess you are using LastFullWeek function as follows

If {Your date field} in LastFullWeek then u201CYesu201D else u201Cnou201D.

Here LastFullWeek function calculates from last Sunday to Saturday.

To get the results form last Monday to Friday using LastFullWeek function write the formula like this.

If {your date field} in minimum(LastFullWeek)+1 to Maximum(LastFullWeek)-1 then u201CYesu201D else u201CNou201D;

I think this will be helpful.

Regards.

[Former Member · Accepted solution]

Aditya!

You have made my day.

I was working along the the similar lines but it wasn't passed my head that I should be using +1 and -1.

Many thanks

10 Stars!!!

Regards

Jehanzeb