mspushypots
New Member
- Joined
- Mar 5, 2018
- Messages
- 4
So I am not really sure how to ask this to search the board and Google is no help, so I am just going to post. I apologize if this has been answered before. Feel free to redirect me ![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have a cell, #1 (A2) that I enter a date in. Cell #2 (AK) is set to =A2 and change the format to MMM YY. What I am wondering is if there a formula that I can use in the cells up and down from AK to convert the value in AK to the prior/subsequent month in the format shown. Or is there a better formula I can use for AK to make this easier? Or am I wishful thinking?
Thanks for any input here!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have a cell, #1 (A2) that I enter a date in. Cell #2 (AK) is set to =A2 and change the format to MMM YY. What I am wondering is if there a formula that I can use in the cells up and down from AK to convert the value in AK to the prior/subsequent month in the format shown. Or is there a better formula I can use for AK to make this easier? Or am I wishful thinking?
![Laugh :laugh: :laugh:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f606.png)