completed week vs incompleted week

[nareshthavidishetty]

hi all,

can any one help me as i struck with the requirement

i want to know whether the week is completed or not as my week starts from Saturday ends on friday, my data will be uploaded daily bases so think that data is uploaded till 13 of this month which is incomplete week bcos complete week is till 15/4/2016,so please tell me how to find complete week

thanks in advance

[swuehl]

Sure, why not just replace the strings with your dates?

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

Date(Max(Date)),

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

)

or

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

'Incomplete: Last update on ' & Date(Max(Date)) ' instead of ' & Weekend(Max(Date),0,5),

'Complete: Last update on ' & Date(Max(Date))

)

Or whatever you want to show.

[nareshthavidishetty]

thanks for the reply

[nareshthavidishetty]

Hi Swuehi,

instead of incomplete week i want to show complete week and previous complete week in the expression can you tell me how to write the expression,so here i don't want incomplete 15/4/2016 week to show only completed week 8/4/2016 and previous completed week 1/4/2016

thanks very much

Naresh

[swuehl]

You can get the previous weekend and the one before using something like

Weekend(Max(Date),-1,5)

resp.

Weekend(Max(Date),-2,5)