TabletWise.com
 

0708 Date Formulas - TODAY() and NOW() w. Shortcut

1 minutes
Share the link to this page
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
A$139.71
List Price:  A$195.60
You save:  A$55.89
৳8,480.01
List Price:  ৳11,872.36
You save:  ৳3,392.34
CA$133.83
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
kr631.94
List Price:  kr884.75
You save:  kr252.80
€84.81
List Price:  €118.74
You save:  €33.93
£76.62
List Price:  £107.27
You save:  £30.65
HK$774.97
List Price:  HK$1,084.99
You save:  HK$310.02
₹7,501.82
List Price:  ₹10,502.85
You save:  ₹3,001.03
RM418.70
List Price:  RM586.20
You save:  RM167.50
₦37,846.21
List Price:  ₦52,986.21
You save:  ₦15,140
kr904.14
List Price:  kr1,265.84
You save:  kr361.69
NZ$151.39
List Price:  NZ$211.96
You save:  NZ$60.56
₱4,907.19
List Price:  ₱6,870.27
You save:  ₱1,963.07
₨16,788.32
List Price:  ₨23,504.32
You save:  ₨6,716
S$137.26
List Price:  S$192.17
You save:  S$54.91
฿3,121.96
List Price:  ฿4,370.86
You save:  ฿1,248.90
₺729.33
List Price:  ₺1,021.10
You save:  ₺291.76
R1,763.59
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In

Transcript

Hello there, it's very important to keep track of time. And that is the reason I'm taking this module where I speak about the formula today and now and also show you a shortcut key. How do you enter current date, current date and time together, depending on whether you want only date or current date plus time. So first things first, a formula which says updates every time you open the workbook, and there's formulas called today equal to today. The good part about it you don't need to enter any parameter just need to close the bracket and press enter it gives you today's date. Similarly, there is a formula called now so n o w, bracket open bracket closed, enter.

This is generally used where you are considering today's date with a predefined date and trying to find the difference that means how many days have passed by since the due date and today. Now, let me also talk about the shortcut key which allows you to enter today's date without You having to type that in and without the use of formula. So I want a static date and that's today's date. So I choose a cell, I press Ctrl semicolon and I press Enter. Now if you want date and time together, then a combination of two shortcut keys one is Ctrl semicolon, then put a space, then press Ctrl Shift semicolon that will give the current time. So date and time put together you have today's date and time.

So that was the formula approach as well as the shortcut based approach.

Sign Up