RE: [ExcelVBA] Date format in formula

 

Totally works ¾ of the time, though. ;)

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of Dr John C Bullas
Sent: Wednesday, 15 February 2012 5:38 AM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Date format in formula

Damn! I was going to say setting month as right("0"&the month
value,2)would always give you 2 digit months.... Ignore me :)

Dr B

On 14/02/2012, Paul Vermeulen <paul.vermeulen@vulcantech.com.au <mailto:paul.vermeulen%40vulcantech.com.au> > wrote:
> Asking for help is always very therapeutic. The solution is to multiply the
> generated string by 1 as follows: =(F2&"/"&E2&"/"&G2)*1. This changes the
> string into a number, and match now returns the correct row number.
>
>
>
> Regards
>
>
>
>
>
>
>
>
>
> Paul
>
>
>
> From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> [mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ] On Behalf
> Of Paul Vermeulen
> Sent: Tuesday, 14 February 2012 7:14 PM
> To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
> Subject: [ExcelVBA] Date format in formula
>
>
>
>
>
> Hi all
>
> Am creating a user sheet where date is entered in three different cells from
> data validation lists as Year, Month and Day, e.g. 2012, 2 and 13
>
> Using concatenate I generate a date string as 2012 & "/" & 2 & "/" & 13 -à
> 2012/2/13.
>
> Using match I am trying to find the row in column A (dates from 2008 to
> 2013) corresponding to the same date. Issue is that "A value is not
> available to the formula or function". I know that it is because my
> concatenated string is not recognised as a Julian number, but I have not
> been successful to fix it.
>
> Advice, anyone?
>
> Regards
>
> Paul
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>

--
Sent from my mobile device

===========================
http://uk.linkedin.com/in/drjohnbullas

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___