how to insert date range automatically which is referring current week?

**pejoi** · 03-06-2014, 11:22 AM

hi guys,
i got a problem with date range.actually i wanna to insert date range automatically which is referring current week.please help...daterange.xlsx

**alansidman** · 03-06-2014, 11:25 AM

In C1 =VLOOKUP(B1,$B$5:$C$57,2,FALSE) if you put the weeknumber in B1

In C1 =VLOOKUP(WEEKNUM(B1),$B$5:$C$57,2,FALSE) if you put a date in B1 or =Today()

**pejoi** · 03-06-2014, 11:27 AM

thank you,alansidman.

how to insert date range automatically which is referring current week?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

how to insert date range automatically which is referring current week?

Re: how to insert date range automatically which is referring current week?

Re: how to insert date range automatically which is referring current week?

Thread Information

Users Browsing this Thread

Similar Threads

How to automatically insert current date when another cell is modified (protected)

How to automatically insert current date when another cell is modified.

How to automatically insert the current date

automatically show data for 3 weeks before & after current week in graph

Can Excel automatically insert current date in a cell?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions