Script for Dropping in a Month in Excel 2003

[mkrawls]

I am working on a large spreadsheet for my company and I have come up with a very complicated formula that looks at two columns of data and then counts if both criteria are met. However, the department I am doing this spreadsheet for wants it as automatically generated as possible and one of the columns needs to have only the month in it for the formula to work.

What I need is a script that will look at a date in one cell and then drop the month of that date into another cell. Any help you can give me would be appreciated!

 

[Jonmo1]

Welcome to the board..

You can do it with a Formula..

If you want the TEXT of the month (January, February, etc)
=TEXT(A1,"mmmm")

If you want the NUMBER of the month (Jan=1, Jan=2, etc)
=MONTH(A1)


Hope that helps.

 

[mkrawls]

That works, but it also poses a new problem. Anytime there's a blank field for the date it automatically puts the date in as January. Since this is a live spreadsheet with data being entered in hourly my tracking data would always be skewed for the month of January. Any suggestions?

 

[Jonmo1]

Assuming you want a blank returned by the formula when the referenced cell is blank..

Try

=IF(A1,TEXT(A1,"mmmm"),"")
and/or
=IF(A1,MONTH(A1),"")

 

[mkrawls]

Thanks! That seems to work!