Hi Everyone :-)
I need help with the following please:
I have a training matrix with the dates of training completion I also have a copy of the same matrix but this one contains due dates so that every time someone puts the date in matrix it will automatically update due dates, this is a formula for due dates =DATE(YEAR(H6)+1,MONTH(H6),DAY(H6)) problem is when I copy this formula across it returns this date 31/12/1900 I can't figure out where this date is coming from there is no date in the matrix cell??? Probably it needs to ignore blanks? I don't know.....
Also I want any cell that is over due base on due date to go red I've tried this but again when copy formula all blank cells in the matrix turned red.
I will appreciate your help
Thank you.
Bookmarks