Lookup Date and find Week Number (Bespoke Calendar)

**Gazsim** · 02-13-2019, 07:57 AM

Hi All,

I am trying to locate a formula for locating the week number from a date from a bespoke calendar. On the attached as an example the date is in Column I and would return the appropriate calendar week from column B in column K and so looking up the date from the range in columns F & G. Is this possible or would I need to reformat to make it so?

Many thanks,
Gaz

**KOKOSEK** · 02-13-2019, 08:10 AM

Try into K2:

Formula:

Please Login or Register  to view this content.

accept with Ctrl+Shift+Enter
I am not sure how You want to set thresholds, I've put >= start, < end, You can change it as You need to.

**Gazsim** · 02-13-2019, 08:30 AM

Hi, it worked OK for the first date I tried (12/9/2018) But then everything else is just returning week 41?

Thanks,
Gaz

**samba_ravi** · 02-13-2019, 08:36 AM

or can try =INDEX(B:B,MATCH(I2,F:F))

**KOKOSEK** · 02-13-2019, 08:44 AM

Originally Posted by Gazsim

Hi, it worked OK for the first date I tried (12/9/2018) But then everything else is just returning week 41?

Thanks,
Gaz

Capture.JPG

Works fine imho. Did you keep proper date format (US, I guess in col F/G)

**KOKOSEK** · 02-13-2019, 08:46 AM

Originally Posted by samba_ravi

or can try =INDEX(B:B,MATCH(I2,F:F))

It will stop working if you resort columns (ex. A or B)

**Gazsim** · 02-13-2019, 08:50 AM

Hi, yes sorry was a format issue with the dates! However have now noticed it is not working when the date falls on the 'end date' from column G?
Thanks
Gaz

**Gazsim** · 02-13-2019, 10:32 AM

Just to note that now resolved - the date had a time attached which wasn't immediately visible,

Thanks

**KOKOSEK** · 02-13-2019, 10:46 AM

You welcome.
If you happy with solution, please use Thread tools and mark thread as SOLVED.

Lookup Date and find Week Number (Bespoke Calendar)

LinkBack

Thread Tools

Rate This Thread

Display

Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Re: Lookup Date and find Week Number (Bespoke Calendar)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Lookup formla to allocate a calendar date to a week based on a table

Find date from year and week number

Get Date from Week Number and Year ( Fiscal Calendar)

[SOLVED] lookup a date according to week number from one worksheet and add it to another

Formula to find week number from a date

date --> calendar week number

vba to find the month and week number from given date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions