Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I make a text box to display the current week number?
HI,
Try this,
=Week(today()) gives 28
Hope it helps
HI,
Try this,
=Week(today()) gives 28
Hope it helps
Hi,
Try this script
=Week(Today())
It displays current week number. Hope this helps you.
Regards,
Jagan.
Is there a way for me to display ie..
"The current week is (week number)"
hi,
try this:
= 'The current week is ' & Week(Today())
Hi,
In text box
= 'The current week is ' & Week(Today())
Hope it helps