New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Using =Text to convert a date in a month

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Using =Text to convert a date in a month

Postby vikas270880 » Sat May 28, 2016 2:07 am

Hi All,

I have two dates in two different columns for example a date in cell A1 and a date in cell B1.

I want to use dates from both of the cells to get the desired output in the following three conditions:

- If A1 is filled and B1 is blank the formula must consider date from A1
- If A1 is blank and B1 is filled, the formula must consider date from B1
- If both the cells are filled, the formula must consider date from A1 only.

is there any possible way for this?

Thanks in anticipation
  • 0

vikas270880
Rookie
 
Posts: 5
Joined: May 28, 2016
Reputation: 0
Excel Version: 2010

Re: Using =Text to convert a date in a month

Postby gebobs » Tue May 31, 2016 10:41 am

Code: Select all
=IF(ISBLANK(A1),B1,A1)
  • 0

gebobs
Regular
 
Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010

Re: Using =Text to convert a date in a month

Postby vikas270880 » Wed Jun 01, 2016 2:17 am

gebobs wrote:
Code: Select all
=IF(ISBLANK(A1),B1,A1)


Hi,

I am trying this:

=TEXT(IF(ISBLANK(H1609),F1609,H1609,"mmm-yy")

in this H1609 is the primary date and F1609 is the secondary date. dont know where I am doing it wrong.
  • 0

vikas270880
Rookie
 
Posts: 5
Joined: May 28, 2016
Reputation: 0
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 54 guests