Conditional Formatting
Closed
gupanjali
Posts
1
Registration date
Monday 9 September 2013
Status
Member
Last seen
9 September 2013
-
9 Sep 2013 à 07:46
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Sep 2013 à 10:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Sep 2013 à 10:34
Related:
- Conditional Formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- Formatting windows 7 - Guide
- Conditional formatting between two values ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Sep 2013 à 10:34
10 Sep 2013 à 10:34
Hi Gupanjali,
Give these formula's a try:
=MID(A1,4,1) to determine the last digit of the year.
=RIGHT(A1,2) to determine the week of the year.
Best regards,
Trowa
Give these formula's a try:
=MID(A1,4,1) to determine the last digit of the year.
=RIGHT(A1,2) to determine the week of the year.
Best regards,
Trowa
