+ Reply to Thread
Results 1 to 4 of 4

date function

  1. 12-01-2013, 09:58 AM #1
    aparunkumar
    aparunkumar is offline
    Registered User
    Join Date
    03-12-2013
    Location
    Thiruvananthapuram
    MS-Off Ver
    Excel 2007
    Posts
    42

    date function

    I have a date in cell A1. Cell B1 and B2 are two other dates. If A1 date is inbetween B1 and B2 dates, then need in B3 cell the data in B5, otherwise B6.
    kindly suggest a solution.
    Reply With QuoteRegister To Reply
  2. 12-01-2013, 10:05 AM #2
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: date function

    Hi, maybe

    Please Login or Register  to view this content.


    Regards
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 12-01-2013, 10:58 AM #3
    aparunkumar
    aparunkumar is offline
    Registered User
    Join Date
    03-12-2013
    Location
    Thiruvananthapuram
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: date function

    Thanks sir, this works
    Reply With QuoteRegister To Reply
  4. 12-01-2013, 11:09 AM #4
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: date function

    Hi,

    thank you for your kind feedback!
    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)

Similar Threads

  1. [SOLVED] Function/formula to compare and insert todays date or yesterdays date
    By TC922 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2013, 05:28 AM
  2. a function to find the previous date based on a given date and a range of dates
    By scott.s.fower in forum Tips and Tutorials
    Replies: 0
    Last Post: 05-30-2013, 07:50 PM
  3. Function that will create a range based on a start date and end date
    By ckosman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2013, 10:09 PM
  4. Function to pull month-to-date, year-to-date for 2009
    By cacjr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2010, 07:57 PM
  5. Date Function formula that will return the date of a specific week
    By Greg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2006, 12:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1