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)
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)