Week no return starting to date against year

Dear Forum Leader,

Week number extract starting to end date corresponding to the year.(Financial calendar)

I am apply the following formula but return the date wrongly.

E2=MAX(DATE(RIGHT(B3,2),1,1),DATE(RIGHT(B3,2),1,1)-WEEKDAY(DATE(RIGHT(B3,2),1,1),2)+(C3-1)*7+1)

YEAR*****WEEKNO**RESULT FORMULA O END DATE

****20/03/2017 **** 17/12/1917
Apr-17*****51 ****26/03/2017 **** 23/12/1917

One error:

RIGHT(b3,2) should be YEAR(B3) as B3 is defined as date.

But still not sure how your result is calculated.

JohnTopley: Thank you so much for your reply. changed the formula but return the date is wrongly. Please help me.

sorry wrong file attached.

Please help me. How do resolve the query.

Originally Posted by JohnTopley

You still have not explained your logic:what is the relationship between April 2017, week no 51 and the date of 20th March. These dates are only two weeks apart. Should the date be in 2018?

I assume 20th / 26th March are the start and end dates of the "week".

Thank for your response Mr.JohnTopley.

I have changed the data in column B year instead of month and year.

Column B&C is a random year and week number for financial calendar. Column D2 and D3 desired result(for financial calendar). My requirements is extract the date range (for financial calendar) from a specific week number and year.

I have apply the following formula =MAX(DATE(B3,1,1),DATE(B3,1,1)-WEEKDAY(DATE(B3,1,1),2)+(C3-1)*7+1) and =MIN(DATE(B3+1,1,0),DATE(B3,1,1)-

WEEKDAY(DATE(B3,1,1),2)+C3*7) based on the link https://www.extendoffice.com/documen...r-to-date.html return the

date range is perfect for calendar year but my requirements the same for financial year.

if possible my requirement? please suggestion and advice.

file attached.

Trying setting date to [B3,4,1] assuming financial year starts April

thanks for your response and help