Returns the current date and time formatted as a date and time.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
NOW()The NOW function is a volatile function that updates whenever the worksheet is recalculated. It is useful for displaying the current date and time on a report or calculating intervals based on the current moment.
=NOW()ผลลัพธ์: 10/25/2023 14:30
Returns the current system date and time.
=NOW()+7ผลลัพธ์: 11/01/2023 14:30
Returns the date and time exactly one week from now.
NOW is a volatile function, meaning it recalculates every time any change is made to the worksheet.