+ Reply to Thread
Results 1 to 6 of 6

Function to detrmine start and end of month

  1. 02-11-2015, 05:16 AM #1
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Function to detrmine start and end of month

    Hello everybody
    I need your help to make this function work
    Please Login or Register  to view this content.
    I tested it but I got no result
    I want to check a date in a cell and if this date is greater than 17 Dec. and less than 16 Jan. the result should be "January"
    Reply With QuoteRegister To Reply
  2. 02-11-2015, 05:51 AM #2
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,968

    Re: Function to detrmine start and end of month

    The date can't be greater than 17 Dec and less than 16 Jan of the same year!
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  3. 02-11-2015, 06:02 AM #3
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Function to detrmine start and end of month

    So how it can be fixed? I tried 
    Please Login or Register  to view this content.
    but no vain
    Reply With QuoteRegister To Reply
  4. 02-11-2015, 06:42 AM #4
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Function to detrmine start and end of month

    I tried this function but I got incorrect results at some dates
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-11-2015, 07:09 AM #5
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,968

    Re: Function to detrmine start and end of month

    Your code isn't entirely clear, but assuming any day after 17 should belong to the following month, try this:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 02-11-2015, 07:57 AM #6
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Function to detrmine start and end of month

    Really wonderful , fantastic, amazing
    I can't imagine it would be so easy like that
    You are perfect Mr. romperstomper
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date function- 1st day of month for 2nd full month from start date
    By vidiotdave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2014, 05:33 AM
  2. Rows of records, each w/ start & end date. Need to compile and summarize month by month
    By jamwil in forum Excel General
    Replies: 6
    Last Post: 03-03-2013, 01:41 AM
  3. Adding a start and finish date to a function counting no. of specific days in month
    By Grimace in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-29-2010, 09:20 PM
  4. Start month, end month and cost.
    By Ainsley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2007, 08:41 AM
  5. Detrmine How Many Rows are Frozen At Top Of Worksheet
    By Mariano42 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2007, 05:21 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1