Skip to Content
0
Aug 01, 2014 at 12:56 PM

formula help

13 Views

Hi

I have a field that contains 7 items (1 for each day)

i.e. Mon_item,

Tues_item

Wed_item

Thur_item

Fri_item

Sat_item

Sun_item

each record can have a mix of items (or none)

i.e Record 1 = Sat_item, Sun_item

Record 2 = Sun_item

Record 3 = none

Record 4 = Mon_item, Wed_item, Sat_item

If the record has an item I would like to display the relevant Day or Days horizontally

i.e. Record 1 = Saturday & Sunday

Record 2 = Sunday

Record 3 = [BLANK]

Record 4 = Monday, Wednesday & Saturday

To make it more difficult I would also like it to display the dates in order based on a date

i.e.

if the date = Saturday then the order of the days should = Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday

if the date = Monday then the order of the days should = Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

if the date = Wednesday then the order of the days should = Wednesday, Thursday, Friday, Saturday, Sunday, Monday, Tuesday