briankpaine briankpaine is offline

Junior Member

Posts: 1

Quote:

Originally Posted by Luke M

With your first date in B1:

=IF(DAY(B1)=1,DATE(YEAR(B1),MONTH(B1),15),
DATE(YEAR(B1),MONTH(B1)+1,1))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Elegant, simple, genius!... Just what I was looking for!

Great job Luke!

Though, I'm new to this site, and not sure where to "click yes"...

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Date Auto Fill	malewis48	Excel Discussion (Misc queries)	3	January 31st 08 06:16 PM
HOW DO I CHANGE AUTO FILL DATE VALUES	Luke	Excel Worksheet Functions	1	January 3rd 07 07:53 AM
Date auto fill	Chris	New Users to Excel	2	October 31st 06 09:26 PM
Should be easy...Auto Date Fill	-emma-	Excel Discussion (Misc queries)	5	July 15th 06 12:28 PM
Auto Date Fill-in	Dreamweavn via OfficeKB.com	Excel Worksheet Functions	2	April 30th 05 09:09 PM

All times are GMT +1. The time now is 11:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us