+ Reply to Thread
Results 1 to 3 of 3

Counting Weekdays

  1. #1
    Registered User
    Join Date
    06-09-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Counting Weekdays

    I want to count the days backwards starting from today. But I want to the cells to fill in with the date (xx/xx/xxxx). Is there a formula that I can use that will start with today and then I can drag that down so it will have the previous day and so forth? I want my spreadsheet to look like this

    example:
    a1 = 06/08/2012
    b1 = 06/07/2012
    c1 = 06/06/2012

    Keep in mind that I only want it to display workdays so dates for Monday through Friday. Any help would be great. Thanks.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Counting Weekdays

    With 06/08/2012 in A1

    In B1 =WORKDAY(A1,-1) >> drag down

    EDIT: I guess I did go the wrong way
    Last edited by jeffreybrown; 06-09-2012 at 09:48 AM.
    HTH
    Regards, Jeff

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Counting Weekdays

    Try

    in b1: =WORKDAY(A1,-1)

    and drag over

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1