Aug 30 2021 05:16 AM
Dear Friends,
Kindly help me the below,
I have data set sheet, And i want to display weeks between two date, which is attached below.
The date duration
Aug 30 2021 05:36 AM
Please clarify week names ("Weel1 Sep", etc.) shall be generated, and if so what is the logic behind, or you keep them predefined?
Aug 30 2021 10:05 AM
Assuming you defined weeks in separate range formula could be
=LOOKUP(2, 1/(close_date >= from_date_range)/(close_date <= to_date_range),weeks_range)