Posted to microsoft.public.excel.misc

mrbalaje

external usenet poster

Posts: 24

First day and Last day of the month to display automatically

If I input the date 11-Apr-2007 in Cell B1. Then the Cell A1 should
automatically display the first day of the month(1-Apr-2007) and the Cell C1
should automatically display the last day of the month(30-Apr-2007).

If i input 12-May-2007 in B1, then A1 needs to be 1-May-2007 and C1 needs to
be 31-May-2007.

Any way to get this?

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
how do I automatically sequence the month	Rubber 4 u	Excel Worksheet Functions	4	February 6th 07 05:38 PM
Display month name instead of number	Office User	Excel Discussion (Misc queries)	3	January 10th 07 06:58 PM
Display Month - 1	HearSay	Excel Worksheet Functions	10	September 30th 06 05:18 AM
Display every 3rd category name but still display latest month	maryj	Charts and Charting in Excel	1	September 24th 06 09:05 PM
How to display month only for date format?	Eric	Excel Discussion (Misc queries)	2	September 24th 06 02:59 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us