upcoming weekday

[bhagi]

Hi all,

I have a Listbox with dates, for example:

11/10/2017

11/11/2017

11/12/2017

11/13/2017

11/14/2017

11/15/2017

...

If I select any date, I need to know which is the next Saturday for that date

how to can i get this?

thanks 

bhagi

[Vegar]

You could solve this by set analysis.Assuming your date field is named [Date] and you have a field containing weekday names named [Weekday]. 

Only({<[Date] ={">$(=only([Date])) <= $(=only([Date])+6)"}, [Weekday] = {'Sat'}>}[Date])

[tresesco]

Or something like:

=Date(DateField+6-Num(Weekday(DateField)))

Assuming Monday is 1 (i.e. - FirstWeekDay=6)

[Chanty4u]

why cant you try this?

SET FirstWeekDay=6;

=WeekEnd(Max(DateField))

[Brett_Bleess]

@bhagi you have received three very good responses to your question on this one, we would greatly appreciate it if you would return to the thread and use the Accept as Solution button on the post(s) that helped you resolve things.  If you did something different, you may post that and mark it after it is posted.

Regards,
Brett