Processing
 

Formulating Date in Excel 2013

08/09/2016 04:59#1

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

I am using MS Office Excel 2013 in English, I have the following question.

I used this formula "=IF(OR(ISNUMBER(D5),ISTEXT(D5)),TODAY(),"not posted")" to place todays date in C5, when I enter text or a number in D5, but I get a number in the returned value, instead of the actual date.

What is incorrect in the formula? explicitly: I enter "yes" in D5 I get "42621" in C5 instead of the current date.

08/09/2016 06:02Top#2

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

Take the cursor to the intended cell and press ALT + H + N + Short Date. This should do the trick!

08/09/2016 05:45Top#3

MJH

Member

Joined at: 9 months ago

Post: 4

Thank: 0

Thanked: 0

There's nothing incorrect in the formula. 42621 is the numeric representation of today's date. Just give cell C5 a Date-type format.

Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

5 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re