Dual Cell Format required

[Guest]

I have a user form where cell A1 is an input field for "WeekNo., or No of
days,
or Date. The date is selected by use of the build in calandar.
The range A2-A12 are referenced to A1+1, A1+2 etc.
This works fine, as long the Date is not used, because the Calendar will
change the cell format to the "date" format.
The formula: = Text(today(),"mm/dd/yy") cannot be used as this format the
cell to text, not allowing the range A2-A12 to be updated when the date is
selected.

help,clue or guidance is appriciated.
Paco.E

 

[Bob Phillips]

You could use

=--A1+1

in A2 instead of

=A1+1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)