View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Excel 97 date diff


wrote:
I should add, I did try the DateDif(..."m") function and variations
This didn't do what I want which is to mark the transition from one
month to the next.


Why not put the date MMM on the row you want in all cells but set
conditional formula to show the font colour white if cell A5 =B5 that
way you will only see it if the month changes

Hope you get the drift