Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
Is there a way I can remove the day from a date reference?<o
></o
>
<o
></o
>
I have a spreadsheet set up to total the costs for certain suppliers in a given month.<o
></o
>
<o
></o
>
however, the data i am able to get from my system shows the date as day / month / year. I want my formula to sum up any costs in the month of a certain year.<o
></o
>
<o
></o
>
Is there anything I can do to the data downloaded to show jsut the month and year? I can obviously format it, but the underlying data is still there, so it doesn’t pick up that it is the information that I require.<o
></o
>
<o
></o
>
Thanks!<o
></o
>
<o
Is there a way I can remove the day from a date reference?<o
<o
I have a spreadsheet set up to total the costs for certain suppliers in a given month.<o
<o
however, the data i am able to get from my system shows the date as day / month / year. I want my formula to sum up any costs in the month of a certain year.<o
<o
Is there anything I can do to the data downloaded to show jsut the month and year? I can obviously format it, but the underlying data is still there, so it doesn’t pick up that it is the information that I require.<o
<o
Thanks!<o