Is there a way to display the week that a date falls within the range

**john dalton** · 10-14-2013, 05:09 AM

Hi,

I have a set of dates that have corresponding weeks attached to them, I need the user to select a starting date and for the week number to be displayed depending on whether the current date falls within the that particular weeks date range.

Please see attached sheet for details.

Thanks in advance

JD

**Fotis1991** · 10-14-2013, 05:12 AM

Perhaps to try

Formula:

Please Login or Register  to view this content.

**john dalton** · 10-16-2013, 07:52 AM

Thats works brilliantly thanks

**Fotis1991** · 10-16-2013, 07:57 AM

You are welcome and thanks for the feedback.

Is there a way to display the week that a date falls within the range

LinkBack

Thread Tools

Rate This Thread

Display

Is there a way to display the week that a date falls within the range

Re: Is there a way to display the week that a date falls within the range

Re: Is there a way to display the week that a date falls within the range

Re: Is there a way to display the week that a date falls within the range

Thread Information

Users Browsing this Thread

Similar Threads

If # falls in between a range then I want it to display a %

Search date range +/- 7 days and return date that falls within range

[SOLVED] Vlookup if date falls within current week

[SOLVED] Pull information based on week date falls under

if date falls within week, count...can it be done?

Bookmarks

Bookmarks

Posting Permissions