Using a cell with a date as part of a new forumal?

[Tricia10]

Hi Everyone,

I am having problems with my spreadsheet and was wondering if the following is possible (I know working with dates in excel can be tricky).


I have some data in another spread sheet that this sheet will use and basically I want to count the records using a certain criteria.

This is the formula I am using for one of my criteria

=COUNTIFS('Import Sheet'!E:E,"Cancelled",'Import Sheet'!D:D,">=09/07/2012",'Import Sheet'!D:D,"<=08/07/2012")

I have to use this formual and variations of this formula throught the sheet and changing the date is very time consuming.

Is it possible to have the date in another cell say B6 (would have the date 09/07/2012) and C6 (would have the date 09/07/2012) and use these cells B6 and C6 as part of the formula?

Everything I have tried so far hasn't worked. Does anyone know anyway this can be done?

Thanks in advance
Trish

[Teethless mama]

Just replace your date in side the quotes with this

">="&B6

"<="&C6

[Tricia10]

Thanks for the quick reponse I have changed the formual to the following

=COUNTIFS('Import Sheet'!D:D,"">="&B6",'Import Sheet'!D:D,"<="&"C6")

However the answer is now "0" and it should be "4". have i got all the " etc in the correct place?

Trish

PS Love your screen name, thats what I keep telling my boys !

[Tricia10]

Thanks got it now, my mistake putting in too many ".

You're awsome

Trish

[Teethless mama]

You're Welcome!