Dates in Excel

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

Guest

I want to use the "IF" function to allocate students to groups based on their
date of birth. I have tried doing this using the format

IF(D2<1/9/1994,"Secondary","Primary")

D2 is the cell with the first student's date of birth. I can't get the
result I want, as all students come out as "primary" regardless of their date
of birth, and even the first student was born in 1989.

Can anybody help?
 
Hi

Try
=IF(D2<DATE(1994,9,1),"Secondary","Primary")

When this doesn't work, check values in column D - are they really dates?
Change cell format in column to numeric - when entries don't change to
numbers, then they are datestrings instead of dates.


Arvi Laanemets
 
it seems correct to me....i tried it out myself and it works....somebody
please share your thoughts.
 
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

Test if a date falls within a given range of dates in Excel? 6
Calculating age from date of birth and ignoring if blank 5
counting the number of dates in a date range 9
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Date Formula 85 factor 7
dates in vb code 8
Looking for exam clashes in excel 0
Completed years and monhts 6

Back
Top