View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Month based data addition to worksheet

I am building a data base in one worksheet that takes data from another
worksheet. The data is filled in monthly but I want to only fill the data in
if the the month is either current month or prior and keep rolling as the
months advance. I have a method to do this if only dealing with one calendar
year (=IF(Previous Month="","",IF(MONTH(TODAY())(MONTH(Previous
Month)+1),Previous Month+32,"")), but this of course doesn't work for a
Dec/Jan transition. Any suggestions?

Also, I'm interested in just date stamping MONTH/YEAR...the day is not
important. In my formula I advance the date by 32 days to advance the date
by a month but there obviously would be a few days of the year where the
formula would break down and the output would not yield what I want (for my
purposes this is not a big deal but if there is a better way to do this...)

Thanks in advance.