# Excel 2003 IF Function using Dates & Text

Solved/Closed
Related:

- Excel 2003 IF Function using Dates & Text
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Print function excel ✓ - Excel Forum
- Number to words in excel - Guide

## 5 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810

Aug 28, 2009 at 06:44 AM

Aug 28, 2009 at 06:44 AM

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

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

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

Thanks for your wonderful expertise!

Regards

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810

Apr 11, 2010 at 09:59 PM

Apr 11, 2010 at 09:59 PM

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.

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.

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810

Apr 11, 2010 at 09:58 PM

Apr 11, 2010 at 09:58 PM

Didn't find the answer you are looking for?

Ask a question
GKaplowitz
Posts
1
Registration date
Friday November 22, 2013
Status
Member
Last seen
November 22, 2013

Nov 22, 2013 at 06:26 PM

Nov 22, 2013 at 06:26 PM

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.

Apr 11, 2010 at 05:54 PM

Jul 9, 2014 at 02:18 AM