Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Formula For Previous Business Day

  1. #1
    Join Date
    7th July 2006
    Posts
    21

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    4th July 2004
    Location
    Canada
    Posts
    2,275

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th July 2006
    Posts
    21

    Re: Formula For Previous Business Day

    Quote 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()
    VB:
    =WORKDAY(Today(),-1) 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Reference Previous Worksheet In Formula/Function
    By aces1110 in forum EXCEL HELP
    Replies: 2
    Last Post: June 16th, 2008, 17:21
  2. Last Business Day Of Prior/Previous Month
    By RB123 in forum EXCEL HELP
    Replies: 4
    Last Post: June 13th, 2008, 04:31
  3. Small Business Formula for Price List
    By homepcsolutions in forum EXCEL HELP
    Replies: 7
    Last Post: July 21st, 2006, 16:19

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno