sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 884
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I have tried to fix the date in a separate column and facing a value error.
Can you please let me know how to fix the below formula?
Regards,
Sanjeev
I have tried to fix the date in a separate column and facing a value error.
Can you please let me know how to fix the below formula?
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | |||||
2 | 11/21/2020 | 21/11/2020 | |||
3 | 20 | 11/21/2020 | #VALUE! | ||
4 | 19 | 11/21/2020 | #VALUE! | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B4 | B2 | =TODAY() |
C2 | C2 | =TEXT(B2,"d"&"/"&"m"&"/"&"yYYY") |
C3:C4 | C3 | =TEXT(B3,DAY(A3)&"/"&"m"&"/"&"yYYY") |
Regards,
Sanjeev