xcellnoob
Board Regular
- Joined
- Apr 6, 2005
- Messages
- 188
Why is this happening?
I have a date in cell A1 Say 5/08/2006
I want cell A2 to display next day. 5/09/2006
I type in cell A2 =A1+1
A2 displays =A1+1 instead of 5/09/2006
What the heck?
I can't seem to get around it.
Help is much appreciated.
I have a date in cell A1 Say 5/08/2006
I want cell A2 to display next day. 5/09/2006
I type in cell A2 =A1+1
A2 displays =A1+1 instead of 5/09/2006
What the heck?
I can't seem to get around it.
Help is much appreciated.