Selasa, 14 Februari 2012

Re: [ExcelVBA] Date format in formula

 

try =DateValue(D2) where D2 is the concatenated cell then format the
cell as date :-)
*Ralph Gregory*
Contracts Manager
t: 01327 708215
m: 07966 341215
www.skaino.co.uk

Skaino Atmos Ltd
West March
DAVENTRY NN11 4SA

Registered in England Number 124 1033
Registered Office: New Creation Farm, Nether Heyford, Northampton NN7 3LB

On 14/02/2012 11:14, Paul Vermeulen wrote:
>
> 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]

__._,_.___
Recent Activity:
----------------------------------
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

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar