If -Then formula needed please... before I head to the roof

Solved/Closed
hotpeppermom
Posts
2
Registration date
Friday August 15, 2014
Status
Member
Last seen
August 18, 2014
- Aug 15, 2014 at 02:55 PM
 hotpeppermom - Aug 22, 2014 at 09:59 AM
Using Excel 2007, I need a formula to do the following:

if the date shown in a cell is 1/31/14, display 'monthly activity - january, or if the date shown is 2/31/14, display 'monthly activity - february ..... and so on for all 12 months.

Thank you in advance,
P

3 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Aug 15, 2014 at 05:22 PM
hotpeppermom, Good evening.

I'm not sure if I understood well your question.
Do you want this formula works always at the last day of month?

Try to use it:
Your date --> A1

C1 -->
=IF(DAY(A1)=DAY(EOMONTH(A1,0)),"monthly activity - " & TEXT(A1,"MMMM"),"")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
hotpeppermom
Posts
2
Registration date
Friday August 15, 2014
Status
Member
Last seen
August 18, 2014

Aug 18, 2014 at 12:29 PM
Hi, and thank you. Yes, it will always be for the last day of the month. Also, where do I enter the formula on the sheet?

This is a snippit of what it looks like originally. Each spreadsheet is over 1000 rows, approx. 100 rows per month. Accounts are sorted by month.
Description Period
Cash - Operating Acct 1/31/2013
GC Redeemed 1/31/2013
Cash - Payroll Acct. 1/31/2013
Due To/From Employees 1/31/2013
Food Cost 1/31/2013
Paper Cost 1/31/2013
Doesn't Matter! 1/31/2013

Cash - Operating Acct 2/28/2013
GC Redeemed 2/28/2013
Cash - Payroll Acct. 2/28/2013
Due To/From Employees 2/28/2013
Food Cost 2/28/2013
Paper Cost 2/28/2013
Doesn't Matter! 2/28/2013

Cash - Operating Acct 3/31/2013
GC Redeemed 3/31/2013
Cash - Payroll Acct. 3/31/2013
Due To/From Employees 3/31/2013
Food Cost 3/31/2013
Paper Cost 3/31/2013
Doesn't Matter! 3/31/2013

I need something that will change it so that the information in column A is a result of the date that is on each row in column B.

Description Period
Monthly Activity - January 1/31/2013
Monthly Activity - January 1/31/2013
Monthly Activity - January 1/31/2013
Monthly Activity - January 1/31/2013
Monthly Activity - January 1/31/2013
Monthly Activity - January 1/31/2013
Monthly Activity - January 1/31/2013
Monthly Activity - February 2/28/2013
Monthly Activity - February 2/28/2013
Monthly Activity - February 2/28/2013
Monthly Activity - February 2/28/2013
Monthly Activity - February 2/28/2013
Monthly Activity - February 2/28/2013
Monthly Activity - February 2/28/2013
Monthly Activity - March 3/31/2013
Monthly Activity - March 3/31/2013
Monthly Activity - March 3/31/2013
Monthly Activity - March 3/31/2013
Monthly Activity - March 3/31/2013
Monthly Activity - March 3/31/2013
Monthly Activity - March 3/31/2013
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Aug 21, 2014 at 06:00 PM
hotpeppermom, Good evening.

"...Yes, it will always be for the last day of the month. Also, where do I enter the formula on the sheet? ..."
Put this formula at your first line of data and copy it down.
Probably C1 or C2

I did an example for you.
http://speedy.sh/jYBzd/21-08-2014-enKioskea-Text-Based-on-Date-OK.xlsx

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
Thank you so very much! This is just what I needed to happen. I never would have gotten this on my own.
Pamm
0