add new calculation to this worksheet

[dougvcd]

can any one tell me how to peform a new calculation to this workbook
colum f wants to show how many tablets are left which i presume will change every day if you see what i mean
cheers
Doug

[davesexcel]

can any one tell me how to peform a new calculation to this workbook
colum f wants to show how many tablets are left which i presume will change every day if you see what i mean
cheers
Doug

Hi,
Try this
=TEXT(C2-(TODAY()-B2)*D2,"0.00")

[dougvcd]

Thank you for that simple when you know how he he he
cheers
Doug