Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
thanks for the reply
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
You can get the previous weekend and the one before using something like
Weekend(Max(Date),-1,5)
resp.
Weekend(Max(Date),-2,5)