Day counter is this possible

Hi

=B1-A1

Format=General

A1=01/02/12

B1=01/03/12

If you mean how many days from one date to the other then just =A2-A1, where A1 contains the earliest date and A2 the latest date.
Format the cell as a number. If you want to see the inclusive total of days then just add +1

thank you guys,

now if i wanted to set charges dependant on how many days there were could i do this eg: amount of money £1000, and the days counted are 1-30 and the charge is 25% then the answer to be £250



thank you for your help

ricky

Hi

=IF(A1<31,B1*C1,0)

where A1 = then number of days, B1 = amount and C1 = %charge.

If the charge % varies with the amount or number of days or both then you'd be better advised to create a VLOOKUP table to determine the % and use the VLOOKUP in the formula instead of C1.

What are your variable values?

i.e. is the charge % dependent on the amount, number of days or both?

Assuming the charge % is dependent on the amount then build a two column table with amounts in the first column and % in the second column.

Then a VLOOKUP would be

=VLOOKUP(amount_cell,your_lookup_table_range,2,False)

Upload a workbook with a table of amounts & % if you need further explanation.

Hello i have attached a work book (example) i need it to look at the number of days in the box labled days on cover then get the relevant percentage and take that away from the premium in the box labelled premium and finally show the figure in the pro rata charge box.

thank you again guys



example.xls

Hi,

A better solution which avoids the need for a table is

E3:
=CHOOSE(MIN(5,ROUNDUP(D3*4/120,0)),25%,40%,55%,75%,100%)*A3