Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Teresa Warne
 
Posts: n/a
Default If both dates are entered into a cell then answer is yes

I would like to enter dates into two different cells. If both of these two
sells have dates in then a third cell will display the word "no"
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=IF(COUNT(A1:A2)=2,"no","yes")

--
Regards
Frank Kabel
Frankfurt, Germany


Teresa Warne wrote:
I would like to enter dates into two different cells. If both of
these two sells have dates in then a third cell will display the word
"no"


  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi Teresa

not sure if you want "yes" or "no" if both cells have dates .. assuming you
want "yes" (as per the subject line) then
=IF(OR(A1="",B1=""),"no","yes")
this means if either of A1 or B1 is blank then display NO, when they both
have something in them then display YES
or
=IF(AND(A1<"",B1<""),"yes","no")
this one says when A1 has something in it, and B1 has something in it then
display YES otherwise display NO.

Note, this doesn't check if the entries are actually DATES or not. If you
need this type of check, please post back with the possible date range that
you are expecting.

Regards
JulieD


"Teresa Warne" <Teresa wrote in message
...
I would like to enter dates into two different cells. If both of these two
sells have dates in then a third cell will display the word "no"



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display answer only in another cell of one containing a formula Mally Excel Discussion (Misc queries) 5 January 21st 05 02:07 PM
Excel: How do I enter a date in one cell & automatically dates adj Shannon Excel Discussion (Misc queries) 4 January 12th 05 01:51 AM
have dates entered from a list of data into an excel template Diane Excel Discussion (Misc queries) 1 December 28th 04 07:33 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 03:06 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"