Week format

[sat_tok52]

Hi Guru's,

I want to display my current week on text object below format,any suggestion please.

Mon 19^th Oct – Sunday 25^th Oct

Thanks,

Satish

[sunny_talwar · Accepted solution]

May be this:

=WeekDay(WeekStart(Today())) & ' ' & Day(WeekStart(Today())) & 'th ' & Month(WeekStart(Today())) & ' - ' &

WeekDay(WeekEnd(Today())) & ' ' & Day(WeekEnd(Today())) & 'th ' & Month(WeekEnd(Today()))

[rubenmarin]

Hi, I don't know how to set the 'th' (the little string version) but for the rest of that:

='Mon ' & Date(WeekStart(Today()), 'DD MMM') & ' - Sunday ' & Date(WeekEnd(Today()), 'DD MMM')

[sunny_talwar]

Or this:

=Date(WeekStart(Today()), 'WWW DD')  & 'th ' & Month(WeekStart(Today())) & ' - ' &

Date(WeekEnd(Today()), 'WWW DD')  & 'th ' & Month(WeekEnd(Today()))

[sunny_talwar]

If 'th' is not important, this should also work:

=Date(WeekStart(Today()), 'WWW DD MMM')  & ' - ' & Date(WeekEnd(Today()), 'WWW DD MMM')

or WWWW for the whole weekday name

[lucasdavis500]

Hi Sunny, to do this for the previous week, would you just insert "-1" after today()? I tried this, and it didn't seem to change my values, unless I have a syntax error..

=WeekDay(WeekStart(Today()-1)) & ' ' & Day(WeekStart(Today()-1)) & 'th ' & Month(WeekStart(Today()-1)) & ' - ' &

WeekDay(WeekEnd(Today()-1)) & ' ' & Day(WeekEnd(Today()-1)) & 'th ' & Month(WeekEnd(Today()-1))

[sunny_talwar]

May be use a comma between Today() and -1

=WeekDay(WeekStart(Today(), -1)) & ' ' & Day(WeekStart(Today(), -1)) & 'th ' & Month(WeekStart(Today(), -1)) & ' - ' &

WeekDay(WeekEnd(Today(), -1)) & ' ' & Day(WeekEnd(Today(), -1)) & 'th ' & Month(WeekEnd(Today(), -1))

[lucasdavis500]

I believe adding "-7" to all of these worked for me

[Anil_Babu_Samineni]

Sunny, This scenario do we get "th" as on CAP. If so, Explain me how do we achieve. Once upon a time i got that issue. But, I got one idea for that like images replace like 1, 2, 3, 4 ... 31 Manually. Do we have any other approach to reach that?

[lucasdavis500]

Try using an if statement that determines what day of the month the above functions resolve to..

ex IF(Day(WeekStart(Today())) = 1, 'st', IF(.......)