Results 1 to 9 of 9

Show same dates every month.

Threaded View

  1. #7
    Registered User
    Join Date
    05-19-2010
    Location
    Newport Pagnell, England
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Show same dates every month.

    This also works:
    For the 1st date
    =DATEVALUE(CONCATENATE("22/",LEFT($B2,FIND("'",$B2)-1),"/",RIGHT($B2,2)))
    For the 2nd date
    =DATEVALUE(CONCATENATE("26/",MATCH(LEFT($B2,FIND("'",$B2)-1),$N$2:$N$13,0)+1,"/",RIGHT($B2,2)))

    if N2:N13 contains a list of January, February, March etc.

    Domski's solution is better I think.
    Last edited by SgtSunshine; 06-17-2010 at 10:40 AM.

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