Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
I want to display my current week on text object below format,any suggestion please.
Mon 19th Oct – Sunday 25th Oct
Thanks,
Satish
May be this:
=WeekDay(WeekStart(Today())) & ' ' & Day(WeekStart(Today())) & 'th ' & Month(WeekStart(Today())) & ' - ' &
WeekDay(WeekEnd(Today())) & ' ' & Day(WeekEnd(Today())) & 'th ' & Month(WeekEnd(Today()))
May be this:
=WeekDay(WeekStart(Today())) & ' ' & Day(WeekStart(Today())) & 'th ' & Month(WeekStart(Today())) & ' - ' &
WeekDay(WeekEnd(Today())) & ' ' & Day(WeekEnd(Today())) & 'th ' & Month(WeekEnd(Today()))
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')
Or this:
=Date(WeekStart(Today()), 'WWW DD') & 'th ' & Month(WeekStart(Today())) & ' - ' &
Date(WeekEnd(Today()), 'WWW DD') & 'th ' & Month(WeekEnd(Today()))
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
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))
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))
I believe adding "-7" to all of these worked for me
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?
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(.......)