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

[Solved/Closed]
Report
Posts
2
Registration date
Friday August 15, 2014
Status
Member
Last seen
August 18, 2014
-
 hotpeppermom -
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

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
2
Registration date
Friday August 15, 2014
Status
Member
Last seen
August 18, 2014

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Thank you so very much! This is just what I needed to happen. I never would have gotten this on my own.
Pamm