Formula For Excel Xls Download

seeking formula that calculates in dd/m/yy. From Date of Joing in cell one to Date of Conformation in cell two.
What formulat to be put in second cell to automatically counts probation months
e.g. 14 May 2011 (6 months) 14 Nov 2011.

Hi Bhardwaj,
Suppose in Cell A1, you are writing the Start Date/DOJ and in Cell B1, you wish to calculate the confirmation date, which is 6 months/180 days from the start date.
Pls follow the following steps:
1. In cell B1, type "=A1+180"
2. Right Click on the cell--> Select Format Cells
3. Click on Tab 'Number', select 'Date option below' and select 'Date Type' e.g. dd/mm/yyyy or dd-mm-yy

ok fine. I have downloaded and kept into pendrive to put into my laptop and during this time if i find prob., i
will contect you.

hi have this advanced formula for AP ptax IF(gross>20000,200,IF(gross>15000,150,IF(gross>100 00,100,IF(gross>6000,80,IF(gross>5000,60)))))

Please find attached document related to your first query here it will give you the exact date as some of the months have a problem of having days like some month have feb has 28 or 29 days some of the month have 30 and 31 days but the formula in attached excel sheet will perfectly work
Yajuvendra Singh Bisht

In excel, how to find difference between to dates. eg. Cell A1 "12/03/1983" and Cell B1 "23/07/1987" in the format dd/mm/yyyy. How to calculate the number of days between the two dates?
Thanking in advance.

Sorry satpreet.
Your formula is not working......if i check it By the formula DATEDIF it showing 5 month in result.