+ Reply to Thread
Results 1 to 4 of 4

Next Date

Hybrid View

  1. #1
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,681
    Assuming B2 will always be earlier than C2 try this formula in D2

    =EDATE(B2,CEILING(DATEDIF(B2,A2,"m")+1,12/C2))

    format as date

    note:EDATE requires Analysis ToolPak add-in, to install use Tools > add-ins and tick "Analysis ToolPak" box

  2. #2
    Registered User
    Join Date
    02-24-2006
    Posts
    24
    Thank you DaddyLongLegs... worked like a charm...

+ 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