人気ブログランキング | 話題のタグを見る

How to Fix Error - Calculating number of years + given date?

Calculating number of years + given date

I made a Formula in (Cell B1) to calculate the period between a given date (Cell A1), and Today ().
This is the Formula in (Cell B1);
=DATEDIF(A1,TODAY(),"y")&" Y- "&DATEDIF(A1,TODAY(),"ym")&" M - "&DATEDIF(A1,TODAY(),"md")&" D"
 
Now I have to add a Column (Column C), this column contains number of years.
 


01/01/12

0 Y- 3 M - 22 D

3


Column (A)

Column (B)

Column (C)


 
 
Now the Formula in Cell (B1) has to be change, I need a Formula to reflect the number of years + the result in Cell (B1).
 
The result will be 3 Y – 3 M – 22 D.
 
Could you please help me in this.

Solutions to the Problem Calculating number of years + given date

Download SmartPCFixer to Fix It (Free)

...
Now I have to add a Column (Column C), this column contains number of years ...

You can adjust TODAY() by constructing an offset date value using either DATE() or EDATE() like this,
DATE(YEAR(TODAY())+C2,MONTH(TODAY()),DAY(TODAY()))
...
or,
EDATE(TODAY(),C2*12)
...
then use that value in your previous formula.

            

The formula in D2 is,
=DATEDIF(A2,DATE(YEAR(TODAY())+C2,MONTH(TODAY()),DAY(TODAY())),"y")&" Y- "&DATEDIF(A2,TODAY(),"ym")&" M - "&DATEDIF(A2,TODAY(),"md")&" D"
...
and the alternate formula in E2 is,
=DATEDIF(A2,EDATE(TODAY(),C2*12),"y")&" Y- "&DATEDIF(A2,TODAY(),"ym")&" M - "&DATEDIF(A2,TODAY(),"md")&" D"

I don't think you will find it necessary to adjust all three of the TODAY() values since you are only adjusting by an integer worth of years but some testing may be worthwhile around Feb 29 of a leap year.


DATE function

EDATE function

YEAR function

MONTH function

DAY function

TODAY function

Using Windows troubleshooter:

  • Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
  • A new window will open. Click View all from the left pane.
  • Scroll down to the bottom and click on Windows update.
  • Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
  • The troubleshooter will automatically detect problems and fix it.
  • Now, close this window and try download/install the app which was previously showing error.

Recommended Method to Fix the Problem: Calculating number of years + given date:

How to Fix Calculating number of years + given date with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: How to Update ASUS Xonar D2X driver for Windows XP 32/64-bit,Update ATI VGA Driver version 6.13.10.5779,How to Download Chicony Camera Driver version 61.005.029.1900,Download OKI C9800(PCL),How to Update TI Card Reader Driver version 2.0.0.10,Method to Download Toshiba Portege R835-P83 eco Utility v.1.3.21.0 driver,Method to Download Toshiba Satellite A660-BT2N23 Face Recognition v.3.1.3 driver,Download Toshiba Satellite L355-S7907 Face Recognition v.2.0.17.32 driver,[Solved] Download Toshiba Satellite L740-BT4N11 PC Health Monitor Utility v.1.7.9.64 driver,How to Download Toshiba Satellite P305D-S8828 WPS Library v.1.0.0.7 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: How to Fix - can i reinstall a corrupted Windows 7 system reserved partition??,Fast Solution to Error: Can formulas take into account the color of the cell on the spreadsheet?,Can I install a XP printer driver in XP Mode? If so, can I use it from Win 7? Tech Support,Troubleshooter of Error: Can I change English language on Windows 8 to Polish?,Tech Support: Can I get a replacement disk if my PC fails,BSOD after upgraded to Windows 8.1 (memory problem?),Blurry programs on Windows 8.1,C:\Window|Microsoft.Net\Framework\v4.0.30319\mscoreei.dll could not be loaded,Browsing history is no longer visible,Bulk deleting from email deleted items folder
by installerror1601 | 2016-08-26 15:19