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
hotpeppermom - Aug 22, 2014 at 09:59 AM
Related:
- If -Then formula needed please... before I head to the roof
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 15, 2014 at 05:22 PM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 21, 2014 at 06:00 PM
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
"...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
Aug 18, 2014 at 12:29 PM
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