J
Juco
In cell A1 I have date of the month ( eg 14 ) for the 14th day
In cell A2 I have month of the tear (eg 9 or 09) for September
In cell As I have the year 2005
the 3 cells would therefore represent the 14th of September 2005
In cell A4 I want....... the 14th september less 72 days to show as dd mm
yy (this is where I need help with a formula)
The client fills in cells A1 and A2 so they may put 9 or 09, does this
present a further problem?
thanks
In cell A2 I have month of the tear (eg 9 or 09) for September
In cell As I have the year 2005
the 3 cells would therefore represent the 14th of September 2005
In cell A4 I want....... the 14th september less 72 days to show as dd mm
yy (this is where I need help with a formula)
The client fills in cells A1 and A2 so they may put 9 or 09, does this
present a further problem?
thanks