LinkBack URL
About LinkBacks
Is there a way to turn a date into the Week (not the Week#). I am talking turning a date into the week that it falls in. Ex: 01/01/10 becomes 01/01/10 - 01/07/10 assuming that 01/01/10 is Sunday.
Is there a way to turn a date into the Week (not the Week#). I am talking turning a date into the week that it falls in. Ex: 01/01/10 becomes 01/01/10 - 01/07/10 assuming that 01/01/10 is Sunday.
Hi,
You had me confused there. I'm presuming that's a typo since 01/01/10 is in fact a Friday.
With the date in A1 use
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
That is why I said assuming that 01/01/10 is a Sunday. I want this to work with any date putting it into the week it falls in. Since 01/01/10 is a friday then it should put 01/03/10 into 01/03/10 - 01/09/10. and so on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks