Results 1 to 13 of 13

Combining two dates formula using IF condition

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    bangalore,india
    MS-Off Ver
    Microsoft 365 MSO (Version 2208 Build 16.0.15601.20858) 64-bit
    Posts
    33

    Combining two dates formula using IF condition

    Hello Gurus,

    I have challenge converting the Text to Date format, i have DMMYYYY, DDMYYYY, DDMMYYYY date formats.

    I have two text with Len=7, ex: 0422024, 4102024, the result should be 04022024 and 04102024.

    I got the formula, but i want to combine two formulas by using IF condition.

    in C1 the the output should be =If (Len(A1)=7, then Date formula1 (B1) or Date formula 2 (B2))

    thanks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combining sheets dates to summary - Formula Error
    By Ravindran Raman in forum Excel General
    Replies: 5
    Last Post: 10-20-2023, 04:57 AM
  2. [SOLVED] Formula using if condition based on dates
    By skml in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-08-2022, 05:59 AM
  3. [SOLVED] IF formula to check value between two dates, add another condition
    By bfaws in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-26-2021, 10:59 AM
  4. [SOLVED] Condition Formula between dates then sum if meets between those dates
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2017, 03:52 PM
  5. [SOLVED] Dates w/in 48 hours of each other formula/condition
    By JRose0303 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2016, 01:28 PM
  6. Formula for parsing and combining dates
    By mjwmedia in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-20-2014, 10:58 PM
  7. formula for combining multiple dates, from columns to rows
    By juliomanco in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-29-2012, 06: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1