current week ,Previous week

[nareshthavidishetty]

Hi all,

i got a requirement like my week starts from sat and ends on Friday so here i wanted to show completed week , and previous week

suppose my data is updated on 17/4/2016 its incomplete week bcos its in between Sat-Fri so here i want to show only completed week and previous week as s well

=If(Max(Date_Trans) < Floor(Weekend(Max(Date_Trans),0,5)),Date(Max(Date_Trans),

Date(Floor(Weekend(Max(Date_Trans),0,5))))

)

this gives me incomplete week ,complete week

[sunny_talwar]

this gives me incomplete week ,complete week

I don't think I understand this last line. What exactly is the issue and what are you trying to do?

[nareshthavidishetty]

hi sunny thanks for the reply

i just want to show the current completed week suppose my week starts from saturday and  ends on fri and my data gets uploaded daily,think it is updated until 17/4/16 and it becomes incomplete ,does it make sense so here i want to show only completed week means till 15/4/2016 and previous week 8/4/2016

thanks

Naresh