Total Pageviews

Tuesday, 2 October 2012

MS Excel: Take input day only from one cell and add month and year automatically

B16 is the cell where I would give the input and make the font color to white so that it is not visible and set this formula to any other cell where full date will be displayed.

=IF(B16<>"", TEXT(B16 & "/08/2012","dd/mm/yyyy"), "")

No comments:

Post a Comment