Posted to microsoft.public.excel.worksheet.functions

Dick Frederick Dick Frederick is offline

external usenet poster

Posts: 2

Help With DATEVALUE

I am sure this has come up before. I wish to return a date in cell (say) B1
to the datevalue in (say) cell B2. Yes, I can type the date in the formula
using quotes, but what I want to do is reverence (say) cell B1 in the
formula and have it return the datevalue. Can anyone tell me how to effect
this? I don't mind using a workaround, but I would not like to use a macro
unless necessary.

TIA,

Dick Frederick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Something other than DATEVALUE	edwardpestian	Excel Worksheet Functions	5	August 9th 06 04:59 AM
Date-related problems - max and datevalue	Dimitri Ulyinov	Excel Discussion (Misc queries)	3	May 28th 06 05:34 PM
DATEVALUE works on one sheet, not another	Kim	Excel Worksheet Functions	4	January 16th 06 05:21 PM
datevalue	LarryTheK	Excel Worksheet Functions	8	July 23rd 05 03:24 AM
Bug in DATEVALUE command in Excel 2002??	MattB-UK	Excel Worksheet Functions	1	February 16th 05 01:03 PM

All times are GMT +1. The time now is 03:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us