+ Reply to Thread
Results 1 to 2 of 2

Datedif rounded up

  1. 12-05-2012, 01:34 PM #1
    HCBalelo
    HCBalelo is offline
    Registered User
    Join Date
    08-18-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    11

    Datedif rounded up

    Hi,

    I'm trying to get a DATEDIF function to ROUNDUP.

    Start Date 1/1/12
    End Date 12/31/012

    I always get 11. I want the answer to be 12.

    Thanks,

    Helder
    Reply With QuoteRegister To Reply
  2. 12-05-2012, 01:45 PM #2
    dogberry
    dogberry is offline
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Datedif rounded up

    Hi

    With your formula add +1 that should do it.


    Chris
    Click my star if I helped Thanks
    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)

Tags for this Thread

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