Extract Month & Year

[howard]

I have text in D1 and would like to extract the month and year - 30 days i.e the previous month and the current year

Book1
	D
1	Date updated: 18/01/2018 17:07
Fixed assets Recon

Cell Formulas
Range	Formula
D1	="Date updated: "&TEXT(NOW(),"dd/mm/yyyy hh:mm")

The month is Jan 2018 in D1 and I would like to extract it as Dec 2017

eg if the date appears as 28/02/2018 then I would to extract the month and year as Jan 2018 etc


Your assistance in this regard is most appreciated

 

[Dave Patton]

You can extract the date and use Edate to calculate previous month.
You can custom format the date or use Text to show the date as text.

Excel 2010
	D	E
1	Date updated: 18/01/2018 17:07	18-Jan-2018 17:07
2		Dec 2017
3		Dec 2017
2a

Cell Formulas
Range	Formula
E1	=RIGHT(D1,16)+0
E2	=EDATE(E1,-1)
E3	=TEXT(EDATE(E1,-1),"mmm yyy")

 

[howard]

Thanks for the help, formulas work perfectly