Date formatting with two range

Brass Contributor

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.

SUDHAKARFRONTIER_0-1630325598213.png

The date duration

SUDHAKARFRONTIER_1-1630325735680.png

 

 

 

2 Replies

@SUDHAKAR-FRONTIER 

Please clarify week names ("Weel1 Sep", etc.) shall be generated, and if so what is the logic behind, or you keep them predefined?

@SUDHAKAR-FRONTIER 

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)