Thread
:
day increasing by 1 when i drag and drop
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
Posts: 11,501
day increasing by 1 when i drag and drop
Hi,
With a date in A1 put this in a2
=A1
now drag A2 and the date wont change.
Mike
"dencara" wrote:
when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you
Reply With Quote
Mike H
View Public Profile
Find all posts by Mike H
day increasing by 1 when i drag and drop