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
[PR]
by installerror1601 | 2016-08-26 15:19

bluetooth driver, windows 7, x64, mini usb bluetooth dongle

I bought a bluetooth dongle from ebay (those really cheap ones).
It doesn't come with software/drivers.
I plugged it in my windows vista laptop and it worked smoothly.
When I plug it in my windows 7 x64 laptop, it says "Unknown device," "USB device
not recognized."  Where can I find the right drivers for this bluetooth dongle?

Few screenshots are as follows:
http://img12.imageshack.us/i/bluetoothnotworking.jpg/
http://img410.imageshack.us/i/csrdevicenotfound.jpg/
http://www.getdirect.com.au/images/Mini%20Square%20Dongle%20main.jpg

Keys to the Problem bluetooth driver, windows 7, x64, mini usb bluetooth dongle

Download Error Fixer (Free)

Hi,
Go to www.bluesoleil.com and download their proggie:
http://www.bluesoleil.com/download/Detail.aspx?TID=26
It is a fully functional demo.
See if it works for you (it did for me).
If it does, then you'll have to shell out (like me) 20 euros.
It works with most of the "abandoned", "old" bluetooth USB devices.
Best of luck.
Carlos

Use the System File Checker tool to repair corrupted or missing system files:

  1. Click Start.
  2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
  3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
  4. Type or copy paste the below command line into it without quotes:
  5. "Sfc /scannow"

Another Safe way to Repair the Problem: bluetooth driver, windows 7, x64, mini usb bluetooth dongle:

How to Fix bluetooth driver, windows 7, x64, mini usb bluetooth dongle with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

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

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Belkin USB Wireless Adapter Not Working With Windows 8.1,Best Way To Create/update Dynamic Range In Excel 2007,Belkin Hispeed Usb Firewire,Bing Cashback Program Troubles,Best Way To Enter Time In A Cell
Read More: Troubleshoot:Battery Notification icon disappeared and Im unable to turn it on (on option is greyed out),[Solved] Black screen on wake-up, but mouse moves cursor arrow,Tech Support: Belkin F5U237v1 7-Port USB Hub,Backup Windows 7 and Restore without removing other partitions Tech Support,Troubleshoot:beta dashboard status code 831188FB,Bing Toolbar has stopped working,bios application not found,bad results when using "find" box on WLM2011, filtered by dates,Black screen on Admin account, but not on standard user account,battery light inconsistent blinking orange and green
[PR]
by installerror1601 | 2016-08-10 17:32