• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to check if a cell contains a Date?

jack abbey

New Member
how to check if a cell contains a Date?
in column A i enter either a date or another value, such as "Dinner" or "Lunch"
in column B i formatted the date to show it to me as i wish, but if in column A its not a date value, then i want column B to be blank
can anyone help me to get that right?
many thanks
 

Attachments

  • Date Test.xlsx
    9 KB · Views: 9
There are a number of choices here that I do not fully understand.
@bosco_yip Why did you choose CELL("type", ... ) rather than ISNUMBER( ... ) ?
@pecoflyer You would still need to test for blank or pick it up at the formatting stage
@jack abbey Why is the text version of the date assembled by concatenating its parts?

The image shows some further options. It seems that much comes down to a matter of taste!

72966
 
hi Peter
thanks for taking your valuable time to help me
you asked me: "Why is the text version of the date assembled by concatenating its parts? "
its just my private preference, because i print out a weekly appointments sheet and all i need is the clear day of the week, and the empty "Space" takes up valuable space, as i have more columns and need to feet them all in one page
 
Back
Top