Prevent and remove arterial plaque naturally. (Health Secrets) The arteries are major blood vessels the heart uses to pump blood from it to the rest of the body. Over time, arterial walls can become congested with a fatty substance known as plaque. When this happens to a severe point, the arteries may begin to harden and the blood flow can become compromised and ultimately result in a heart attack. Mainstream medicineâs approach for treating plaque is to use drugs or surgery.
Adding Dates You can add some number of days to a date by simply using the =SUM function. Since Excel stores dates as a number of days, no further work is required. For example, to add 5 days to 1/1/98, in A1, use =A1+5, which gives 1/6/98.To add a number of months or years to a date, you first need to decompose the initial date into its year, month, and day components, add in the desired offset, and then have Excel put the components back together.For example, say you have a date in A1, to which you want to add 3 months and 4 days.or example, adding 6 months and 10 days to 8/25/97, in A1 with the formula. =DATE(YEAR(A1),MONTH(A1)+6, DAY(A1)+10). Generally, you cannot add two dates that are in serial format. For example, adding 1/15/1998 and 6/15/1998 gives 6/30/2096, which is essentially meaningless.
This is a discussion on How to add 6 months to a date? within the Excel Questions forums, part of the Question Forums category; Hi guys, I need a formula that will add six months to a date, while keeping the day the same. Lets say I have 10-15-11 entered in A1. I want A2 to show 4-15-12. It's important that the particular day stay the same, in this case it must be the 15th both times. Thanks! Share Share this post on.