Dates can be daunting for those of us who don’t find the logic of time all that intuitive. But there’s no need to worry! Excel makes it easy to manage dates and even add a month to an existing date. Read on and find out how!
Make Dates Bright in Excel
Excel is the perfect tool to make sense of dates. With its helpful functions, you can quickly and easily manipulate dates, adding and subtracting days, months, and years. But first, you need to understand how Excel reads dates.
By default, Excel reads dates in the American format. That means that the date “9/2/2020” is read as September 2nd, 2020. But if you’re using a different date format, such as the DD/MM/YYYY format, you’ll need to make sure you convert the date in Excel so it reads correctly.
Adding a Month of Fun!
Once you’ve got the date in the right format, you’re ready to add a month. This is easily done with the help of two functions: EDATE and DATE.
The EDATE function will work with any given date, and quickly adds or subtracts a month. All you need to do is write EDATE, followed by your date and the number of months you want to add or subtract. For example, “=EDATE(A2,1)” would add one month to the date in cell A2.
The DATE function works in a similar way, though it’s more suitable for larger time ranges. You need to specify the year, month and day, for example “=DATE(2020,9,2)” which would return the date 2nd September 2020.
If you’ve ever been confused when it comes to dates, Excel is the perfect tool to help you out. With the help of EDATE and DATE functions, you can quickly and easily add a month or two to any date. So get your calendar ready and make the most of the time you have!