-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cell Value transfer based on Calendar date
- Thread starter jb1994
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,491
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
If your values were in cells A2:A4 and "FY24" was in cell B1 and you wanted to copy them to B2:B4, you could place this formula in cell B2 and copy it down to B4:
However, that would just copy the values and not remove them from the FY23 column.
If you actually want to move them (so they no longer remain in column A), that cannot be done with a formula. That would require VBA.
If your values were in cells A2:A4 and "FY24" was in cell B1 and you wanted to copy them to B2:B4, you could place this formula in cell B2 and copy it down to B4:
Excel Formula:
=IF(TODAY()>=DATE("20"&RIGHT($B$1,2),4,1),A2,"")However, that would just copy the values and not remove them from the FY23 column.
If you actually want to move them (so they no longer remain in column A), that cannot be done with a formula. That would require VBA.
Upvote
1
