View Single Post
  #1   Report Post  
BACITH BACITH is offline
Junior Member
 
Posts: 1
Default How to replace a constant from a cell containing date and time

In the below example the number in the bracket is the no of days elapsed from the date given in the cell till today. this is a software generated report which shows the aging. i want to take only the no of days. i want to replace date and time. please help me to do so. Below it shows the date and time the data was entered to the software and the no of days elapsed.

2012-05-21 08:11:42( 135)


Thankyou