+ Reply to Thread
Results 1 to 9 of 9

links / EOMONTH function

Hybrid View

  1. 09-26-2007, 10:06 AM #1
    drecollet
    drecollet is offline
    Registered User
    Join Date
    02-20-2007
    Posts
    17
    bumb, any ideas?
    Reply With QuoteRegister To Reply
  2. 09-26-2007, 11:43 AM #2
    kraljb
    kraljb is offline
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    Try this instead of the EOMONTH formula... (gets the same result)

    =DATE(YEAR(A1),MONTH(A1),1)-1

    Hope that helps...

    John
    Reply With QuoteRegister To Reply
  3. 09-27-2007, 08:19 AM #3
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699
    Quote Originally Posted by kraljb
    =DATE(YEAR(A1),MONTH(A1),1)-1
    ...although the formula I suggested above is shorter and does the same....

    =A1-DAY(A1)
    Reply With QuoteRegister To Reply
  4. 10-01-2007, 01:10 PM #4
    drecollet
    drecollet is offline
    Registered User
    Join Date
    02-20-2007
    Posts
    17
    both worked, thanks

    edit sorry I missed your solution the first time daddy
    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)

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