Reporting Month - MS Excel

September 20, 2018 at 01:17:35
Specs: Windows 7
Hi,

Can you please help?

Is there a formula I can use in MS Excel where I put in a date in cell A1 and then it gives me a reporting month value in cell A2. For e,g.

Example 1 - date of 12/9/2018. This gives a reporting month of September.

Example 2 - date of 16/11/2018. This gives a reporting month of November.

Example 3 - date of 29/03/2018. This gives a reporting month of March.

Thanks in advance.


See More: Reporting Month - MS Excel

Reply ↓  Report •

#1
September 20, 2018 at 03:22:49
I'm currently using this formula.

=TEXT(K13,"mmmm")

K13 is the cell with a date in it.

If I put a date of 13/9/2018 in K13 it brings back a value of September.

However, when there is no date in K13 then it brings back January.

It shouldn't bring back any month if the data is not there.

Can you please help me resolve this issue.

Thanks


Reply ↓  Report •

#2
September 20, 2018 at 07:34:42
Try this and see how it works:

=IF(K13="","",TEXT(K13,"mmmm"))

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#3
September 20, 2018 at 08:57:27
This formula didn't work either. It gave me an answer of January because I have a default in the selected field.

Is there anyway round it?


Reply ↓  Report •

Related Solutions

#4
September 20, 2018 at 10:02:14
I have a default in the selected field.

Have no idea what your talking about.

Please explain exactly what your doing, use Row/Column
and include all data required.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

Ask Question