hi, I know you can subtract 2 dates e.g. cell A1 has 12/3/2015 and cell A2 has 20/3/2015 by using =A2-A1, which gives you 8 days or by using =datedif(A1,A2,"d")....but can you use a cell reference which has a date and subtract an actual date e.g. =A1-01/03/2015 or is this a no no...it's just that I wanted to quickly test some date differences without putting the second date in a cell...