Excel 2003 IF Function using Dates & TextSolved/Closed

Question

Hello,
I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but if the date is between 01/01/1996 and 31/12/1997 it will read U14 and if the date is later than 01/01/1998, it will read U12.

Thanks for any help.

venkat1926 · Accepted Answer

your date entry is in A1

try this formula

=IF(AND(A1>="1/1/94"+0,A1<="12/31/95"+0),"U16",IF(AND(A1>="1/1/96"+0,A1<="12/31/97"+0),"U14",IF(A1>=1/1/98,"U12","")))

study this carefully so that you an create such a formula in future

remember in excel the dates are entered as mm/dd/yy
that is 5/10/94 is 10th May 1994

Jen · Answer

Fantastic!  that worked perfectly. I was just about going nuts trying to work it out - and see that I was nearly there, but even being just a little wrong makes a world of difference.

Thanks for your wonderful expertise!

Regards

venkat1926 · Answer

https://ccm.net/forum/affich-151869-excel-2003-if-function-using-dates-text#newanswer

venkat1926 · Answer

uni111
mistake in my replly 

uni111
regarding your question can you post a small extract of your data with coloring
and give examples what you want. Let us try. 
greetings.

GKaplowitz · Answer

This formula works!!!  However, I need to add more to the formula with this concept:  Let's say there are 2 columns, one column contains start date and 2nd columns contains end date, answers will go to 2 columns if for example:  start date column has "7/20/2013", then end date has "8/4"/2013", the July column should have 1 as value and August should have 1 value for having value on end date for august.  If both start date and end date falls within same month  then the value in zugust should be "0".  I need help with the formula.   Thanks.

Excel 2003 IF Function using Dates & Text

5 responses

Similar discussions

Subscribe To Our Newsletter!