Posted to microsoft.public.excel.programming

David

external usenet poster

Posts: 195

Date manipulation within text entries

Using XL2K:
A2 contains text 'From: Feb 16th'
C2 contains text 'To: Feb 28th 2005'

For alignment purposes I don't want to split to separate cells, but would
like to programatically increase the dates to next bi-monthly period AND
use proper ordinals 'st' or 'th' in the result.

Am I asking too much?

--
David

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
Count instances of text in date entries	MilusC	Excel Worksheet Functions	11	August 2nd 08 05:48 PM
Date & Phone Manipulation	Ray S.	Excel Discussion (Misc queries)	2	June 30th 08 08:37 PM
Date Manipulation	Greg	Excel Discussion (Misc queries)	2	November 7th 06 10:22 PM
Problem with Date Manipulation	Sbufkle	Excel Discussion (Misc queries)	4	November 24th 05 03:40 PM
Date manipulation question	NikkoW	Excel Programming	2	May 14th 04 04:17 PM

All times are GMT +1. The time now is 06:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us