IIII
New Member
 Joined
 Jan 26, 2021
 Messages
 3
 Office Version

 365
 Platform

 Windows
 Mobile
 Web
Hi All  I am just looking for some help on the following issue :
I am trying to find a way where, I can return the week number, within a specified date range, based off an entered date.
In the example below, if I enter a date in column E, column F will return the Period for which that date falls under and column G should return the week number, from within the corresponding date range.
Sorry if this doesn't make sense, please do not hesitate to ask any clarifying questions.
Thanks in advance for any help provided.
Cheers.
I am trying to find a way where, I can return the week number, within a specified date range, based off an entered date.
In the example below, if I enter a date in column E, column F will return the Period for which that date falls under and column G should return the week number, from within the corresponding date range.
Date return example.xlsx  

A  B  C  D  E  F  G  H  I  J  K  
1  ID #  First name  Last Name  Referred to  Initial referred date  Period  Week  Start  End  Period  
2  123456  Jane  Doe  John Doe  08/02/2021  1  2  01/02/2021  12/04/2021  1  
3  123457  Jane  Doe  John Doe  07/05/2021  2  3  20/04/2021  29/06/2021  2  
4  123458  Jane  Doe  John Doe  01/09/2021  3  8  05/07/2021  13/09/2021  3  
5  23/09/2021  02/12/2021  4  
6  
Sheet1 
Cell Formulas  

Range  Formula  
F2:F4  F2  =IF(AND(E2>=I2,E2<=J2),K2,IF(AND(E2>=I3,E2<=J3),K3,IF(AND(E2>=I4,E2<=J4),K4,IF(AND(E2>=I5,E2<=J5),K5,"Outside period")))) 
Sorry if this doesn't make sense, please do not hesitate to ask any clarifying questions.
Thanks in advance for any help provided.
Cheers.