Trouble with EDATE function

Dooha

New Member
Joined
Apr 20, 2011
Messages
25
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.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Should the formula be this?

=SUMIF(Flying!B7:B322,">"&EDATE(TODAY(),-9),Flying!K7:K322)
 
Upvote 0

Forum statistics

Threads
1,224,574
Messages
6,179,633
Members
452,933
Latest member
patv

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top