How to Define the Date Format in a Formula

[azad092]

Dear Members
good morning

I am using a formula to display the sum of a range including the date ranges like as in DASHBOARD C11 is start date and in DASHBOARD D11 is end date... the given below formula works perfectly but there is one problem....it display the date as general value instead of date in date format ... Petty Cash Bills From 44606 To 44606 Rs.0
Even I have set the date format in the data source and formula cell.... please guide me in this issue
="Petty Cash Bills From "&DASHBOARD!C11&" To "& DASHBOARD!D11 & " Rs."& SUMIFS(C4:C1000000,A4:A1000000,">="&DASHBOARD!C11,A4:A1000000,"<="&DASHBOARD!D11)

 

[StephenCrump]

="Petty Cash Bills From "&TEXT(Dashboard!C11,"d mmm yyyy") &" To "& TEXT(Dashboard!D11,"d mmm yyyy") & ....

Change the "d mmm yyyy" to your desired format.

 

[azad092]

="Petty Cash Bills From "&TEXT(Dashboard!C11,"d mmm yyyy") &" To "& TEXT(Dashboard!D11,"d mmm yyyy") & ....

Change the "d mmm yyyy" to your desired format.

thanks for your good response
its working perfect
thanks again