Date and Time Formulas

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])
TaskStart DateEnd DateDate FormulasAnswerResults
Content Development04/17/2307/17/23TODAY()7/27/2023Returns current date
Write ContentNOW()7/27/2023 12:09Returns  current date and time
Proof Content Development04/17/2307/17/23DAYS(end_date,start_date)91Returns the number of days between the End Date and the Start Date
SME Review04/17/2305/20/23NETWORKDAYS(start_date,end_date,{holidays])25Returns the number of workdays between the Start Date and  End Date
Facebook
Youtube
Pinterest
LinkedIn