struggling with a macro... Purpose is to validate from a range of dates in specific columns (column 5, 7, 9, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31, 33, 35) if there are any dates falling on Saturdays or Sundays.
If so, a warning will popup with the cell reference.
This is what I am using:
Issue: it is pointing out to the incorrect cell that doesn't have a weekend day (E169). And it misses the one I know it's Saturday (E1239). Changed already several things and cannot figure out
Thank you so much!