bcurtis208
New Member
- Joined
- Apr 1, 2011
- Messages
- 6
Hi Everyone,
I'm hoping I can get assistance with this formula I'm trying to figure out. I have in the spreadsheet I'm working on a date in R2 of 01/20/2014. I would like to have it show in JC2 that the date that is in R2 is within the Week of 01/19 - 01/25.
Also, if the value of R2 was for example was 02/27. I would like the formula in JC2 to show the week ending to a date that lands at the end of the month. So I'd like the formula in JC2 to show result as: 02/23 - 02/28, I wouldn't want that range to end in 03/01 instead of 02/28.
I hope that makes sense. I appreciate any assistance I can get. Thank you so much.
I'm hoping I can get assistance with this formula I'm trying to figure out. I have in the spreadsheet I'm working on a date in R2 of 01/20/2014. I would like to have it show in JC2 that the date that is in R2 is within the Week of 01/19 - 01/25.
Also, if the value of R2 was for example was 02/27. I would like the formula in JC2 to show the week ending to a date that lands at the end of the month. So I'd like the formula in JC2 to show result as: 02/23 - 02/28, I wouldn't want that range to end in 03/01 instead of 02/28.
I hope that makes sense. I appreciate any assistance I can get. Thank you so much.
Last edited: