Question about Microsoft Office Professional 2007: Windows

I want calculating the days between the months.

formula will be using in ms excel

Please visit to learn all excel functions and formulas

All-in-One Excel
Functions and Excel Formulas

Posted on Nov 08, 2012

For example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Posted on Aug 25, 2008

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

I assume that the dates you want adjust are in date form and are in regular columns (or rows).

If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))

where the original date is in cell A3.

You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))

where the original date is in cell A3.

You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

Oct 17, 2013 | 1996 Italdesign Formula

Format cells A1 and B1 to dates.

A1 is the first date

B1 is the 2nd date

C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

A1 is the first date

B1 is the 2nd date

C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

Jun 23, 2011 | Microsoft Excel for PC

You could do a simple +NOW-START DATE

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?

Jun 05, 2009 | Microsoft Excel for PC

Try this formula=((A1)*(1+A2))-A3
Where:
A1 is the original Balance
A2 is the interest rate
A3 is the money paid for the preceding month

Apr 02, 2009 | Microsoft Excel for PC

To calculate the difference in Years use =Year(c,r)-Year(c,r)

To calculate the difference in Months use =Month(c,r)-Month(c,r)

To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

To calculate the difference in Months use =Month(c,r)-Month(c,r)

To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

Assuming you put the start date in cell A1, put this formula:

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

use the below formula to get the date of the LWD (Monday thru Friday) of the month.

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

First type in 31-Aug-1974 in Cell = C1

then in the calculation cell use this formula

=text(C1,"dddd")

this yields Saturday in text

then in the calculation cell use this formula

=text(C1,"dddd")

this yields Saturday in text

Jul 29, 2008 | Microsoft Excel for PC

Dear chidambar, thats usually because you've mistakenly tampered with a file or because you're putting an inapplicable value. Can you tell me what error is it exactly ?

you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.

if that has helped you plz press fixya.

you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.

if that has helped you plz press fixya.

Dec 13, 2007 | Computers & Internet

244 people viewed this question

Usually answered in minutes!

×