Announcement

Collapse
No announcement yet.

Formula For Previous Business Day

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Formula For Previous Business Day

    Hello, I need a excel formula or an excel vb formula to find the business day previous to today. For example if today was a monday Feb 14th I would need the formula to return Friday Feb 9th or 2/2/2007 not Sunday Feb 13th. Does anyone know of a way to do this?

  • #2
    Re: Formula For Previous Business Day

    Have a look at the WORKDAY function...

    =WORKDAY(A2,-1)

    ...where A2 contains your starting date.

    Hope this helps!

    Comment


    • #3
      Re: Formula For Previous Business Day

      Originally posted by Domenic
      Have a look at the WORKDAY function...

      =WORKDAY(A2,-1)

      ...where A2 contains your starting date.

      Hope this helps!
      Thank you for your response! it works
      All I had to change was make A2 to equal today()
      Code:
      =WORKDAY(Today(),-1)

      Comment

      Working...
      X