Does Excel think that there is always 29 days in Feb ? I'm doing a spreadsheet that has leadtime dates on it and formulas calculate dates every seven days. It always includes the 29th Feb and throws all my formulas out !
Whats the difference between CONCAT and CONCATENATE?
Like someone once said to me - A computer will only do what you tell it. The dates were for some reason 2004 and not 2005 ( can't work out why that happened) so now I have ammended them it now takes feb as having 28 days - thanks for the help guys !