Thread: edate 1 March!!
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Yangas View Post
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?