Help Pls...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everybody,

Using IF() function, how can i check whether a cell contains Date value or
not.

Ex.( if A1 is equal to date then 'OK' else 'Pls enter date')

Regards
 
Inspired by a previous Dave Peterson post ...

Try in B1:
=IF(A1="","",IF(LEFT(CELL("format",A1),1)="D","OK","Pls enter date"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls help to find number of days for ageing report 3
Formula IF 1
Concatenate 1
Help!!!!!! 2
macros for print 5
Urgent Help pls.... 1
Vlookup Help 5
Week Day formula usage???? 9

Back
Top