Nesting

TClark14 · Apr 5th, 2002, 09:22 AM

In F1 I need a formula that will look at the date in E1 and if the date is any date in Jan, then put in column F a 1, if it is a February date, then put in column F a 2, and so on.

Can someone tell me how to do this?

Thanks
Terry

Mark W. · Apr 5th, 2002, 09:29 AM

No IF is required. Use...

=MONTH(E1)

Aladin Akyurek · Apr 5th, 2002, 09:29 AM

Quote:

On 2002-04-05 08:22, TClark14 wrote:
In F1 I need a formula that will look at the date in E1 and if the date is any date in Jan, then put in column F a 1, if it is a February date, then put in column F a 2, and so on.

Can someone tell me how to do this?

Thanks
Terry

In F1 enter & copy down:

=MONTH(E1)

TClark14 · Apr 5th, 2002, 09:33 AM

Thanks - I always think must be more complicated than they really are. So easy I never would have figured it out. Thanks Again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 09:22 AM	#1
TClark14 New Member Join Date: Apr 2002 Posts: 9	In F1 I need a formula that will look at the date in E1 and if the date is any date in Jan, then put in column F a 1, if it is a February date, then put in column F a 2, and so on. Can someone tell me how to do this? Thanks Terry

Apr 5th, 2002, 09:29 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	No IF is required. Use... =MONTH(E1)

Apr 5th, 2002, 09:33 AM	#4
TClark14 New Member Join Date: Apr 2002 Posts: 9	Thanks - I always think must be more complicated than they really are. So easy I never would have figured it out. Thanks Again.