Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October

M

Martin Los

1. "Get text string on basis of date":

In cell A1 I have a date with format "dd/mm/yyyy" (for example
"27/10/2004"). Now I want to get in cell B1 a text string telling me the week
that date falls into (for example "Monday 25th - Sunday 31st October").

What function do I have to use in cell B2 to get this text string?

2. "Get text string on basis of weeknumber":

In cell A1 I have the number of a week (WEEKNUM(A1;2)). How can I get in B1
a text string telling me the week that date falls into (for example "Monday
25th - Sunday 31st October") using the value of the weeknumber in A1?

TIA

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct" 3
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October 4
Weeknum(today()) gives wrong weeknummer 6
Inverse to WEEKNUM 12
converting date to a monday date 4
Need to auto-enter last updated date, only if another cell has changed 1
Weekly or Bi-weekly dates 4
Default IF Date Is between 2 Dates then output additional column 1

Top