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
=TEXT(A1-WEEKDAY(A1)+1,"dd/mm/yy")& " - "&TEXT(A1-WEEKDAY(A1)+7,"dd/mm/yy")
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my 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
Reply With Quote
Bookmarks