Forum Discussion

lantanagal's avatar
lantanagal
Copper Contributor
May 20, 2020

How do I use the plus and minus key to change date in a cell?

How do I use the plus and minus key to change date in a cell?  I can't remember what combination of keys to use (this is in Office 2007).  Example - cell contents are 05/20/20 and I want them to be 0...
excel
Abiola1's avatar
Abiola1
MVP
May 20, 2020
You can do A1+1 I you have the date 05/20/20 in cell A1. That will deliver 5/21/20

Is that what you mean?
ede6340's avatar
ede6340
Copper Contributor
May 21, 2020
if you want 'yesterday' you can use =TODAY()-1,+ for tomorrow (etc.), use =TODAY() if today's date is the goal.

Resources