This is about ms excel formulas?

Question

I'm not really good at excel, so i hope this will be understandable:
Is it possible to create a formula in excel that will count the number of days between two different dates (in two different cells)?. If so please tell me how, thanks in advance :)

Answer 1

1. Open Excel
2. On the top tool bar click the question mark
3. In the Office Assistant text box
type in
Calculate the difference between two dates

You will be given the step by step instructions.

k
p.s. Use the Office Assistant for
lots of functions
including getting all sorts of formulas.

Answer 2

A pivot table could be the least confusing, yet you prefer a formula so ok. First the pivot table. spotlight each and every of the cells that incorporate data, inclusive of the header information. pass to data>Pivot table. while the communique container opens, click end. The Pivot table container checklist will open. Drag the data to the a approaches precise column and to the data container. this could be rapidly set to count type. it promises you a count type and a precis of each and every down the left column. precise click on the desirable left gray button and choose container Settings. A communique will open permitting you to alter on your desires. each time you upload new data, you will might desire to refresh the pivot table by precise clicking everywhere on the table and choose Refresh. AutoFilter: go with the cellular on the desirable of your checklist and click data>clear out>vehicle clear out. A drop down container will seem. click on the arrow and choose the clear out standards "New Dehli", no fees. seem on the backside left nook of your demonstrate screen. it is going to say "x of xx data stumbled on". this promises you a rapid count type. formula: go with and empty cellular and form =countif(a1:a1000,"New Dehli") this might count type each and every of the data that have the desirable textual content cloth "New Dehli", no fees, in them. you will might desire to go with various cells to place this formula in. replace "New Dehli" with "Agra", and so on. as needed. that's greater often than not executed on your precis tab. It does not might desire to be on the comparable artwork sheet.

Answer 3

not able to understand ur question clearly plz describe openly.

Answer 4

You can find all that and more here: http://www.mrexcel.com/board2/