Thread: Month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lightbulb lightbulb is offline
external usenet poster
 
Posts: 61
Default Month

I have a column of dates, and I want a formula that will subtract one month
from that date. I can't simply subtract 30 from the date b/c sometimes that
will still be in the same month (i.e. - July 31 - 30 days= July 1)...and I
can't simply subtract 31, because seometimes that will be 2 months earlier
(i.e.- July 1 - 31=May 31). Any help?

Thanks!