edate 1 March!! - ExcelBanter

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by Yangas

Hi I'm using =edate(a1,1) a1 being =date(year(x), month(x),day(today()) then =edate(a2,1) then =edate(a3,1) etc
and I get problems with any day after 28 - thanks Feb!!

Is there anyway to get this displaying correctly for days such as 31st of a month?

What is it you're actually trying to show?

Which version of Excel are you using?

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
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia	Damon Longworth	Excel Worksheet Functions	0	February 26th 08 02:51 AM
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia	Damon Longworth	Excel Worksheet Functions	0	February 4th 08 04:17 AM
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia	Damon Longworth	Excel Programming	0	February 4th 08 04:17 AM
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia	Damon Longworth	Excel Programming	0	January 11th 08 12:47 AM
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia	Damon Longworth	Excel Programming	0	November 21st 07 03:22 AM

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

Menu

About Us