Date formatting with two range

%3CLINGO-SUB%20id%3D%22lingo-sub-2698416%22%20slang%3D%22en-US%22%3EDate%20formatting%20with%20two%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698416%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Friends%2C%3C%2FP%3E%3CP%3EKindly%20help%20me%20the%20below%2C%3C%2FP%3E%3CP%3EI%20have%20data%20set%20sheet%2C%20And%20i%20want%20to%20display%20weeks%20between%20two%20date%2C%20which%20is%20attached%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SUDHAKARFRONTIER_0-1630325598213.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306653iE72A693923485D1A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SUDHAKARFRONTIER_0-1630325598213.png%22%20alt%3D%22SUDHAKARFRONTIER_0-1630325598213.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20date%20duration%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SUDHAKARFRONTIER_1-1630325735680.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306654i2B64D59B5226B113%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SUDHAKARFRONTIER_1-1630325735680.png%22%20alt%3D%22SUDHAKARFRONTIER_1-1630325735680.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2698416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2698449%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20formatting%20with%20two%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931234%22%20target%3D%22_blank%22%3E%40SUDHAKAR-FRONTIER%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20clarify%20week%20names%20(%22Weel1%20Sep%22%2C%20etc.)%20shall%20be%20generated%2C%20and%20if%20so%20what%20is%20the%20logic%20behind%2C%20or%20you%20keep%20them%20predefined%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)