• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

past 13th month name needed from existing month

R

Rinki

Member
Hi,

I am having a data whereby I have April 2016 mentioned with no exact date.

I am interested in finding a formula which would give me output as existing minus 13th month .
Example today is april 2016..
I want a formula that would give me march 2016 as output.

plz see i dont have dates in my data and hence i am curious.

I tried =EOMONTH(R2,-13) which gives me date in the output which is not what i want.

plz help me with correct formula.
 
If EOMONTH calculates, then R2 must contain valid Excel Date Value.

Even if the display shows Month & Year only, Excel Date Value contains date information as well.

Do you just need the month & year displayed or are you using that info for later calculation? Solution will vary depending on your need.

Sample workbook will be helpful (along with expected output).
 
So it looks like you need text display only. Use this then.
=TEXT(EOMONTH(B2&" "&A2,-13),"mmm yyyy")

Alternately you can use Custom format on cells and use "mmm yyyy" as format.

See attached (you don't need Col C).
 

Attachments

Hi,

I could develop a column that would display today - 13th month but how to show those lapsed account names which would say that these are the accounts who have not given us any rev at all in last 13months from this month onwards.

also please see it needs to be refreshed every month.
I have attached dummy file.
 

Attachments

You must log in or register to reply here.
Back
Top