How can use datevalue formula?

**Akatecho** · 08-31-2015, 03:14 AM

Dear All,

I try to use formula "DateValue" but is does not work, it shows #Value.

Can you help and advice me please?

you can see in this attached file.

Best regards,

**Akatecho** · 08-31-2015, 03:28 AM

ready to get answer close issue

**azumi** · 08-31-2015, 03:38 AM

Why you use DATEVALUE function when your date is real date? Don't quite understand.........

**Ace_XL** · 08-31-2015, 04:16 AM

You just need

=TEXT(A1-90,"DD-MMM-YYYY")

How can use datevalue formula?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How can use datevalue formula?

Re: How can use datevalue formula?

Re: How can use datevalue formula?

Re: How can use datevalue formula?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Excel formula: Month(DateValue(x & "1"))

#VALUE! error in SUMPRODUCT with DATEVALUE formula, when there are blank lines in the data

DATEVALUE used for Criteria range in SUMIFS formula

[SOLVED] HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(,

[SOLVED] datevalue

[SOLVED] datevalue

[SOLVED] datevalue

datevalue

Bookmarks

Bookmarks

Posting Permissions