mdeora
Reputation: 4534
How to get output of today() function as string in google sheet
I want to append quote to the date value which i receive from =today()-1 function.
Expected output is eg. - "30/05/2018"
Upvotes: 0
Views: 55
Answers (1)
mdeora
Reputation: 4534
Could Achieve with below -
=CONCATENATE(CHAR(34),TO_TEXT(today()),CHAR(34))
Upvotes: 1
Related Questions
- Get today date as title in of google sheet by google appScript
- Get the date with format on google sheets script
- Google Sheets how to get value on certain row if the column is Today()?
- How can i get day from google sheet via google script
- How to pull date from cell and compare it to today's date
- Display today's date in every cell in a single column in a google sheet
- Google Script: getValue from row with today's date
- How to get the data for today's date from multiple cells?
- Need help to output vba excel function as date value
- Excel print =TODAY() as value