Hello, need help!
Cell 1: 20/09/2009
Cell 2: 3
Now I want cell 3 to display 20/09/2012. Can anyone help?
Greetings
Hello, need help!
Cell 1: 20/09/2009
Cell 2: 3
Now I want cell 3 to display 20/09/2012. Can anyone help?
Greetings
try
=EDATE(A1,B1*12)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Maybe:
=A1+DATE(A2,1,0)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks