Posted to microsoft.public.excel.misc

stevieb

external usenet poster

Posts: 16

Date Calculation

Hello,

I am trying to duplicate the following formula as a macro in vb:
B1=TEXT((MID(A1|1|4) & "/" & MID(A1|5|2) & "/" & MID(A1|7|2))-6|"YYYYMMDD")

I have following data in A:
20080101
20080102
....
20080131

I would like to then subtract 6 'days' from those values so that we have
this in B:
20071226
20071227
....
20080125

I've tried using the Format() function but it not displaying correctly.

Thank you

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
End Date Calculation (adding a start date duration)	Silena K-K	Excel Discussion (Misc queries)	5	January 25th 08 04:27 PM
date calculation	praveen	Excel Worksheet Functions	1	May 25th 07 08:00 AM
Tricky Date calculation: How to calculate a future date	[email protected]	Excel Discussion (Misc queries)	9	August 11th 06 04:24 AM
Date Calculation	Alpur	Excel Discussion (Misc queries)	0	November 15th 05 02:38 PM
Date Calculation	Mukund	Excel Worksheet Functions	3	January 11th 05 11:29 AM

All times are GMT +1. The time now is 01:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us