+ Reply to Thread
Results 1 to 18 of 18

Help - date substraction

Hybrid View

TAKTOUKA Help - date substraction 05-18-2005, 12:23 PM
dominicb Good evening Taktouka Type... 05-18-2005, 03:12 PM
TAKTOUKA Hi Dominique, Thank you... 05-19-2005, 02:55 AM
mangesh_yadav One way is to format the... 05-19-2005, 03:08 AM
TAKTOUKA By formating the result as... 05-19-2005, 03:56 AM
mangesh_yadav Sorry, my mistake. Thats not... 05-19-2005, 04:40 AM
mangesh_yadav A slight varaition: ... 05-19-2005, 04:42 AM
TAKTOUKA Wrong formula still trying to... 05-19-2005, 07:31 AM
mangesh_yadav can you give an example where... 05-19-2005, 07:34 AM
mangesh_yadav Try: ... 05-19-2005, 07:42 AM
TAKTOUKA Did you test the last... 05-19-2005, 08:55 AM
TAKTOUKA Did not get it yet 05-19-2005, 11:15 AM
  1. 05-19-2005, 04:42 AM #1
    mangesh_yadav is offline
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    A slight varaition:

    =YEAR(A2)-YEAR(A1)-IF(MONTH(A2)>=MONTH(A1),0,1) & " " & 12-(MONTH(A2)-MONTH(A1))-IF(DAY(A2)>=DAY(A1),0,1) & " " & IF(DAY(A2)-DAY(A1)<0,DAY(DATE(YEAR(A2),MONTH(A2),1)-1)+(DAY(A2)-DAY(A1)),DAY(A2)-DAY(A1))


    - Mangesh
    Reply With QuoteRegister To Reply
  2. 05-19-2005, 07:31 AM #2
    TAKTOUKA is offline
    Registered User
    Join Date
    05-18-2005
    Posts
    9
    Wrong formula still trying to get it. Thank you for your help
    Reply With QuoteRegister To Reply
  3. 05-19-2005, 07:34 AM #3
    mangesh_yadav is offline
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    can you give an example where it is failing

    Mangesh
    Reply With QuoteRegister To Reply
  4. 05-19-2005, 07:42 AM #4
    mangesh_yadav is offline
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Try:

    =YEAR(A2)-YEAR(A1)-IF(MONTH(A2)>=MONTH(A1),0,1) & " " & (MONTH(A2)-MONTH(A1))-IF(DAY(A2)>=DAY(A1),0,1)+IF(MONTH(A2)<MONTH(A1),12,0) & " " & IF(DAY(A2)-DAY(A1)<0,DAY(DATE(YEAR(A2),MONTH(A2),1)-1)+(DAY(A2)-DAY(A1)),DAY(A2)-DAY(A1))


    - Mangesh
    Reply With QuoteRegister To Reply
  5. 05-19-2005, 08:55 AM #5
    TAKTOUKA is offline
    Registered User
    Join Date
    05-18-2005
    Posts
    9
    Did you test the last formula????
    Reply With QuoteRegister To Reply
  6. 05-19-2005, 11:15 AM #6
    TAKTOUKA is offline
    Registered User
    Join Date
    05-18-2005
    Posts
    9
    Did not get it yet
    Reply With QuoteRegister To Reply
  7. 05-19-2005, 04:58 PM #7
    TAKTOUKA is offline
    Registered User
    Join Date
    05-18-2005
    Posts
    9

    Still need help

    Still need help
    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