I am having trouble using the EDATE function accross multiple worksheets. I am wondering if it's because I am using office 2003.
The formula I am using is:
=SUMIF(Flying!B7:B322,">"&EDATE(TODAY(),-9),K7:K322)
If I use this formula on the same worksheet, is works fine. But when I try and use it for another worksheet (titled 'flying'), it doesn't work. I can sum from a different worksheet no problem i.e =SUM(Flying!K7:K322).
I can only assume it is because of the version of office I am using. Unless I have made an error in the formula. Any help would be appreciated.
The formula I am using is:
=SUMIF(Flying!B7:B322,">"&EDATE(TODAY(),-9),K7:K322)
If I use this formula on the same worksheet, is works fine. But when I try and use it for another worksheet (titled 'flying'), it doesn't work. I can sum from a different worksheet no problem i.e =SUM(Flying!K7:K322).
I can only assume it is because of the version of office I am using. Unless I have made an error in the formula. Any help would be appreciated.