
Not applicable
2012-07-11
08:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Current week
How do I make a text box to display the current week number?
3,751 Views
1 Solution
Accepted Solutions

MVP
2012-07-11
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
Try this,
=Week(today()) gives 28
Hope it helps
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
3,496 Views
5 Replies

MVP
2012-07-11
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
Try this,
=Week(today()) gives 28
Hope it helps
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
3,497 Views

.png)
Luminary Alumni
2012-07-11
08:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this script
=Week(Today())
It displays current week number. Hope this helps you.
Regards,
Jagan.
3,496 Views

Not applicable
2012-07-11
08:58 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a way for me to display ie..
"The current week is (week number)"
3,496 Views

Not applicable
2012-07-11
09:00 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
try this:
= 'The current week is ' & Week(Today())

MVP
2012-07-11
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
In text box
= 'The current week is ' & Week(Today())
Hope it helps
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
