+ Reply to Thread
Results 1 to 3 of 3

creating a list of running dates excluding sundays

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    birmingham england
    MS-Off Ver
    2010
    Posts
    63

    creating a list of running dates excluding sundays

    Hi, I have followed some advice to allow a list of dates excluding sundays. However i have encountered a problem.
    In A1 I put the date: 23/04/12.
    Then in A2 i put '=A1 +1 +(WEEKDAY(A1) =7)' as directed.
    I then dragged the litte black cross down and it populated the the fields in that column.
    That produced this:
    41023
    41024
    41025
    41026
    41027
    41029
    41030
    41031
    41032

    I notice that 41028 is missing, which would be the sunday date so something about the formulae is right, however. as you can see there is no date formatting, am i doing something wrong?

    Thanks for your help.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: creating a list of running dates excluding sundays

    If you format A2 before drag-copying, it will work out fine.

  3. #3
    Registered User
    Join Date
    04-18-2012
    Location
    birmingham england
    MS-Off Ver
    2010
    Posts
    63

    Re: creating a list of running dates excluding sundays

    ..*facepalm*
    OF COURSE!!! how did i miss that...thanks for your help

+ 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