Posted to microsoft.public.excel.programming

external usenet poster

Posts: 112

Calculate Month

I have a table with column headers

8/1/2004 9/1/2004 10/1/2004 ... 3/1/2005

I have to find the column that is 5 months from today and insert a column.
If I run the macro on the 1st of the month or the 31st of the month I should
find the same column.

Thanks,
Denise

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
formula to calculate month-month	User	Excel Discussion (Misc queries)	2	February 16th 10 10:28 AM
calculate month	RJ	Excel Worksheet Functions	9	September 25th 08 03:06 PM
calculate year and month	michelle	Excel Discussion (Misc queries)	9	May 23rd 08 08:54 AM
Calculate the first day of the month for the current month?	April S.	Excel Discussion (Misc queries)	5	July 27th 05 08:53 PM
Calculate Month	Denise	Excel Programming	1	November 4th 04 02:42 AM

All times are GMT +1. The time now is 08:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us