
Many professions- sales, retail, medicine, law, business-are date driven. Here is a Table that shows some of the Date Formulas.
Four Useful Date and Time Formulas
- TODAY()
- NOW()
- DAYS(end_date,start_date)
- NETWORKDAYS(start_date,end_date,[holidays])
Task | Start Date | End Date | Date Formulas | Answer | Results |
Content Development | 04/17/23 | 07/17/23 | TODAY() | 7/27/2023 | Returns current date |
Write Content | NOW() | 7/27/2023 12:09 | Returns current date and time | ||
Proof Content Development | 04/17/23 | 07/17/23 | DAYS(end_date,start_date) | 91 | Returns the number of days between the End Date and the Start Date |
SME Review | 04/17/23 | 05/20/23 | NETWORKDAYS(start_date,end_date,{holidays]) | 25 | Returns the number of workdays between the Start Date and End Date |