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

Copper Contributor

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 05/21/20 by pressing the '+' key in combination with another key - which one, though?

3 Replies
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?
if you want 'yesterday' you can use =TODAY()-1,+ for tomorrow (etc.), use =TODAY() if today's date is the goal.

@lantanagal 

I don't remember how exactly it works, but perhaps you mean the date picker - the object which allows to add date value to the cell selecting it from calendar and change the value by shortcut like this.

 

Date picker object is not available any more in modern Excel, but perhaps this functionality will be returned back one day. You may vote for this here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054...