Date to week convert

[silambarasan.J]

Hi,

How do covert date to week.

file attached herewith.

pls help me.

[Glenn Kennedy]

It's not clear which direction you want the formula to work in.

Are you trying to convert Week-01 to a date range (and if so - why does week 1 correspond to a date in March); or do you want to convert a range to a week number???

[silambarasan.J]

Each Month i have weekly wise report Generate.(From Monday to Thursday)

So I have Select the date Range are

02.03.2015-05.03.2015 -Week-01

06.03.2015-12.03.2015-Week-02

13.03.2015-19.03.2015-Week-03

20.03.2015-26.03.2015-Week-04

27.03.2015-31.03.2015-Week-05

if not possible date against corresponding value of Text(Week)?

or pl convert a range(Date) to week number.

pl help me.

[Ali Kırksekiz]

Check the files.