+ Reply to Thread
Results 1 to 9 of 9

Show same dates every month.

Hybrid View

excelkeechak Show same dates every month. 06-16-2010, 09:18 AM
excelkeechak Re: Show same dates every... 06-17-2010, 08:01 AM
Domski Re: Show same dates every... 06-17-2010, 08:11 AM
Dulanic Re: Show same dates every... 06-17-2010, 08:30 AM
excelkeechak Re: Show same dates every... 06-17-2010, 09:33 AM
excelkeechak Re: Show same dates every... 06-17-2010, 09:37 AM
SgtSunshine Re: Show same dates every... 06-17-2010, 10:36 AM
excelkeechak Re: Show same dates every... 07-05-2010, 03:32 AM
excelkeechak Re: Show same dates every... 07-12-2010, 12:21 PM
  1. #1
    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.

+ 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