How to Create a Formula to Increase a Date by 1 Month?

By

Microsoft Excel is a powerful program. If you are using it for a calendar or anything else where you might need to find the date exactly 1, 2, or 3 months after another date here is a formula you can use.

Turn on your computer and open a new or existing Excel spreadsheet.WH.performance.mark('step1_rendered');

In any cell, for this example we will use A2, type in you date. Ex. 1/1/2006

In a different cell, for this example we used B2, type in the amount of months cell A2 is to be incremented by. Ex. 5

In the last cell type the formula:
=DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+1,0))))replacing what is in bold with the appropriate cells for your spreadsheet.

You will see that this cell now has the calculation desired.

Another option is to use =EDATE(start_date,months)
This is a simpler method but can only be used if the Analysis ToolPak add-in is installed.
See full

Comments

Post a Comment

Popular posts from this blog

How to Find Your XBox 360 Serial Number?

By
Image
Finding the Serial number of your Xbox 360 is easy. Choose your preferred method, then perhaps you might even like to decipher the serial numbers to find out exactly when and where your Xbox was manufactured. Checking the back Look on the back of your Xbox. Look near the A/V,HDMI,I/O(USB) and Ethernet ports.WH.performance.mark('step1_rendered'); Find a sticker near these parts. The sticker will have a barcode on it. Look above that barcode. There should be bold numbers followed by words. For example: MFR Date (Manufacture Date, the date when your XBox was made) . Look under the MFR Date. You will find your Xbox 360's Serial Number. Checking the USB portal Open up the USB port in the front of your console. Look for a sticker with a number. This should be the serial number. Checking System Information Go to System Information. It will display your Serial Number. Cracking the code - LNNNNNN YWWFF On the bottom of the Xbox 360, you will be able to see the Xbox 360 manufacturing...
Read more

How to Make a 1 Ohm to 100 Megaohm Resistance Decade Box?

By
Image
A variable resistor with a built in readout is very useful for electronics hobbyists. A method to construct a 1 ohm to 100 mega ohm resistance substitution box is provided here.. Be sure that you have all of the things needed.Eight thumbwheel decade switches (shown in the image). Make sure not to buy BCD-encoded decade switches. These have to be 10-way decade switches with 11 connectors per switch. Unlike BCD-switches which have only 5 connectors. You can buy these switches from a surplus store, but they are available at about $1-3/switch.WH.shared.addScrollLoadItem('img_d27d541283')Resistor assortment containing at least nine values of 1, 10, 100, 1000, 10k, 100k, 1M, 10M ohm resistors. In this example, 3 W resistors are used, but 1/4 W or even 1/10 W will be enough as well. Be aware, that using smaller wattage or surface mount resistors will limit the current and voltage. The 1/4 W resistors are easy to solder due to their small size. The 3W resistor set can be bought from eB...
Read more

How to Connect Xbox 360 Wired Controller to PC Windows 8?

By
This wikiHow teaches you how to connect a wired Xbox 360 controller to your Windows 8 PC. In order for this process to work, you must be using a hardwired Xbox 360 controller; the USB charge-and-play cable that you can plug into wireless controllers will not allow you to connect to a PC. Downloading the Drivers Open the Xbox 360 controller drivers page. From here, download the drivers from the "Download" section. These drivers will make your Xbox 360 controller work with Windows 8's operating system.WH.performance.mark('step1_rendered'); Click the box beneath the "Software & Drivers" heading. Doing so will prompt a drop-down menu with all of the available drivers for the Xbox 360 controller. You'll see two Windows 7 options here: "32-bit only" and "64-bit only".If the page doesn't scroll down automatically, first scroll down to below the "Free Shipping. Free Returns" banner and click Download on the right side of...
Read more

How to Get a Million Dollars in Gran Turismo 4 in 1 to 2 Hours?

By
Image
You may have Gran Turismo 4 but not a lot of money. Doing this multiple times will make you have enough money to buy the most expensive cars in the game. To complete this, you must have at least 25% completion. Get a car. Get car fast enough to beat Vipers and Series One Supercharged. To get one to beat these guys, read "How To Make A Fast car In Gran Turismo 4 For Less Than 100,000" under related wikiHows.WH.performance.mark('step1_rendered'); Go Race. Once you have the car, its time to race! Go to the Endurance Hall and go to El Capitan 200 miles (320 km). Select "race" and you should be at another screen within 20 seconds. Select B-Spec mode and press R-1. Make sure the "1-2-3-4-5" at the top is set to 3. Hit triangle and another light should illuminate. Hold down L-1 and press the left arrow on the D-pad so it is set to go 3x the regular speed. Watch. Sit back as the computer does the work, and even pits automatically! However, you will have to...
Read more

How to Redeem the Cerberus Network Code for Mass Effect 2 on Xbox 360?

By
Image
This article is how to redeem the code for the Cerberus network on Xbox 360 Create a Bioware Social Network account and link you Xbox live gamertag to your BSN account.WH.performance.mark('step1_rendered'); Start up your Xbox 360 and switch to online profile/gamertag and download any updates. Insert your Mass Effect 2 disk into your 360 and wait for it to autoplay if you have autoplay enabled or if autoplay is disabled press start and download the update if it says you need to. On the main menu press Y to bring up the Cerberus network redeem screen and enter your BSN username,email address and password then enter your unique 16 digit code then highlight done on the onscreen keyboard and press start it will say code redeemed then you will go back to the main menu and press y again to bring up the Cerberus network menu and download the free content. See more
Read more

How to Hook up an Xbox 360?

By
Image
For parents with younger children, hooking up a Xbox 360 can be challenging (even more challenging to someone who's new to the world of video game consoles). This will be a great help to people who want to teach this to their children or learn this for themselves. Prepare a workspace. Before bringing the Xbox in, prepare a hard, flat surface near your TV. Take the Xbox out of the box and put in on this surface. Then, remove all of the cords from the box.WH.performance.mark('step1_rendered'); Connect the display output cables. If you have an HDTV, plug the HDMI cable in. Otherwise, use the cord with the yellow, white, and red wires. Make sure the cable you have selected is plugged into both the TV and the Xbox! Connect the power cord. Plug one end of the cord into the Xbox, and the other into the power brick (pictured above). Plug the power brick into an outlet. Make sure the outlet is close enough to where you plan to keep the Xbox. Turn the console on. Now that the wires a...
Read more

How to Create a Hunger Games Minigame in Minecraft PS3/ Xbox 360 Edition?

By
Image
Creating a decent Hunger Games world without the mods that the PC/Mac edition offers can be tricky, but with a little imagination and a sense of what to do will result in hours of fun for you and your friends (or bitter enemies)! Here are some tips, tricks, and guidelines for making the perfect Minecraft Minigame to scatter your opponent's pixels all over the ground. Choose a biome (or create your own).This is pretty obvious but you need a biome to increase or  decrease the difficulty of the game. For example, a desert offers no food and no shelter, so it would be a very quick game. However, if you have a jungle, players have loads of food and tons of hiding spots.WH.performance.mark('step1_rendered'); Set a spawn point. Also very important: a spawn point. To do this, place a couple of beds and have your "tributes" sleep in them. Bear in mind that you have to do this at night. Bonus: have a "Cornucopia" like they have in the book with chests with supplie...
Read more

How to Use an Xbox 360 Headset?

By
Image
Assuming you have already brought your headset for your Xbox 360 from a respectable retailer, or you are using the standard one you got with your new Xbox 360, you now need to use it. But how do you connect it? This is a little how-to for people who are new to the Xbox or people who aren't too sure on how to do it. There are many headsets official and unofficial which are usable with the Xbox 360. The one key thing to remember is that you have two types which are wireless and wired.WH.performance.mark('step1_rendered'); If you have a wireless headset or earpiece you will need to charge it fully first. All wireless headsets come uncharged when brought new, much like a mobile phone. Now on to the connection of the headset. First make sure your Xbox 360 is on, you can see the display on the television and your controller is synced with the Xbox 360 as player one. For a wired headset plug the 2.5mm pin into the bottom of the controller listening for a small click. For older mod...
Read more

How to Burn Xbox 360 Games onto DVD Discs?

By
Image
Backing up your game collection on the Xbox 360 can be tricky. There are several anti-piracy protections that need to be bypassed in order to play burnt games, and if you're not careful you can find yourself with a lot of DVD coasters. Follow this guide to successfully burn your backups to DVDs. Game piracy is illegal, this guide is for backing up copies of games that you own. Preparing to Burn Flash your Xbox 360. Your Xbox should be flashed with the latest version of the iXtreme LT+ firmware. You can either do this yourself or find someone to do it for a fee. It involves opening the Xbox, identifying the DVD drive manufacturer, connecting the DVD drive to your PC, and then installing custom firmware onto the Xbox DVD drive. This will allow your Xbox to play backup DVDs.WH.performance.mark('step1_rendered'); Acquire your games. To burn a game, you will need the .iso file that is created when the disc is ripped to a computer. There are two main ways that you can get an Xbox...
Read more

How to Remove Known Wireless Networks from a Windows 8.1 Update 1 PC?

By
Image
Do you have a network that you don't travel to very often saved in your list of known networks on your Windows 8.1 Update 1 PC? This article can give you the details on how you can manage and remove these not-so-often-used-(but-saved-anyways) networks. Open the Windows 8.1 Update 1 PC to any app. Whether that be the Desktop app, or one of the many other apps you have on your PC, open up one of them.WH.performance.mark('step1_rendered'); Open the Charms bar. Press ⊞ Win+C to open it up. Select the Settings option from the bar that results. Click the "Change PC settings" option that is located at the bottom of the screen. Click the "Network" option from the left tabs area of the screen. Look for and click the "Manage known networks" link from below the "Wi-Fi" section label on the page to the right of the tabs section. Single-click the network name that the network has titled itself as, and click the "Forget" button. Read more
Read more