Wednesday, 15 August 2012

How to get Date value from a cell having Date and Time

Get Date value from a cell having Date and Time in Excel
Suppose cell A2 have a date and time but if you want only date in B2 then simply use the following formula.

=DATE(YEAR(C1),MONTH(C1),DAY(C1))

Example :



Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts