Hiya-
i'm not sure what formula you're using-
I put a random date in A1 and pasted the following formula in B1 & C1:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+1)
it increased the day by 1 in both cells.
I then changed the format to UK and it worked just fine.
Is this what you're looking for?
If not let me know,
pim
--
Pim
------------------------------------------------------------------------
Pim's Profile:
http://www.excelforum.com/member.php...o&userid=27565
View this thread:
http://www.excelforum.com/showthread...hreadid=470707