Euro5
asked on
excel previous month in yyyymm format
I need a cell that will pull the previous month in this format yyyymm.
For instance, this is July, so I need the cell to populate 201606 (june 2016)
August should be 201607
Also, I need a rolling 12 month also, so if the result is 201607, I need another cell to populate 201508
Can anyone help??
For instance, this is July, so I need the cell to populate 201606 (june 2016)
August should be 201607
Also, I need a rolling 12 month also, so if the result is 201607, I need another cell to populate 201508
Can anyone help??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you may replace the second formula with this....
=EOMONTH(EDATE(A2,-12),2)
Open in new window
and then custom format the formula cell with yyyymm.Now for another date you may have something like....
Open in new window