RE: [ExcelVBA] Date format in formula

 

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@yahoogroups.com] On Behalf Of Paul Vermeulen
Sent: Tuesday, 14 February 2012 7:14 PM
To: ExcelVBA@yahoogroups.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]

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 5

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

.

__,_._,___