YesConsulting
New Member
- Joined
- Jan 7, 2019
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
- MacOS
To show todays date the formula =Today() in a cell returns just that... A formatted date : 1/13/19
I have a cell to show the week number and todays date
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in; mso-page-orientation:landscape;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding:0px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} --> </style>
<colgroup><col width="87" style="width:65pt"> </colgroup><tbody>
<!--StartFragment-->
<!--EndFragment-->
</tbody>
This returns :
<colgroup><col span="2"></colgroup><tbody>
</tbody>
I have a cell to show the week number and todays date
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in; mso-page-orientation:landscape;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding:0px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} --> </style>
="Week: " & ISOWEEKNUM(TODAY() + 1) & " " & TODAY() |
<colgroup><col width="87" style="width:65pt"> </colgroup><tbody>
<!--StartFragment-->
<!--EndFragment-->
</tbody>
This returns :
Week: 3 43478 | |
I expected it to return : Week 3 1/13/19 It would be even better to return : Week 3 Jan 13, 2019 but that may be too much?! Besides not making sense (to me) why the function does not function the same... I cant find any formatting function that works at the cell level. The Format() only works in VB. This seems like a dummy question, like it should be obvious.. But having spent quite a bit of time on it has me perplexed. I am prepared to be embarrassed. | |
<colgroup><col span="2"></colgroup><tbody>
</tbody>