| 1. | =Now() - Get the current Date and time (changes when recalculated) |
| 2. | Ctrl+; (semicolon) - Get current date |
| 3. | Ctrl+: (colon) - Get the current time |
| 4. | Get the current date and time (doesn't change) Ctrl+; space Ctrl+: |
| 5. | =text(date,"mm/dd/yyyy") - different ways to format dates in a string |
| 6. | Number of days - subtract 2 cells with dates =A1-A2 (A1 should be after A2) format as a number |
| 7. | Day of week =text(date,"ddd") |
| 8. | Convert String to date = datevalue("1/2/2019") |
| 9. | Weekend - =weekday(date) = 1 to 7 (Sun. to Sat) |
| 10. | Holidays - create a holiday table and use vlookup |
| 11. | Get just the date =int(now()) |
| 12. | Get the time only - =now() - int(Now()) |