Posted to microsoft.public.excel.programming

denise

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 days in a month	N Harkawat	Excel Worksheet Functions	2	September 16th 08 08:46 PM
calculate Age Year Month & day	shailendra joshi	Excel Discussion (Misc queries)	3	September 6th 08 03:33 PM
Calculate the first day of the month for the current month?	April S.	Excel Discussion (Misc queries)	5	July 27th 05 08:53 PM

All times are GMT +1. The time now is 07:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us