Thread: Input Boxes & getting tied up in knots with strings!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MSP77079[_33_] MSP77079[_33_] is offline
external usenet poster
  
Posts: 1
Default Input Boxes & getting tied up in knots with strings!
How about this?

Days = Day(Range("F6"))
Months = Month(Range("F6"))
Years = Year(Range("F6")) + CertLife

Range("F7") = DateValue(Months & "/" & Days & "/" & Years

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote