How to Add 30 Days to a Date in Excel – 7 Quick Methods

30 or any number of days can be added to a date, using different functions

add 30 days to a date in excel overview

 

Method 1 – Using an Algebraic Formula to Add 30 Days to a Date

Steps:

  • Cell C5 and enter:
=B5+30
  • Press Enter, to see the 1st date value.
  • Drag the Fill Handle to autofill the rest of the cells in Column C.

add 30 days to a date with algebraic formula addition

Read More: How Do I Add 7 Days to a Date in Excel


Method 2 – Using the EDATE Function to Add 28/29/30/31 Days to a Date

Steps:

  • In C5, enter the EDATE formula.
=EDATE(B5,1)
  • Press Enter and autofill the entire column to see the output.

add 30 days to a date with edate function

Read More: How to Add Months to Date in Excel


Method 3 – Using the Paste Special Option to Add 30 Days to a Date

Step 1:

  • Select  D7 (cell containing the number of days to add).
  • Press CTRL+C to copy it.

add 30 days to a date with paste special

Step 2:

  • Select the cells containing the dates.
  • Select Option and choose Paste Special.

add 30 days to a date with paste special

Step 3:

  •  In Paste, select Values.
  • In Operation, select Add.
  •  Press Enter.

add 30 days to a date with paste special

The new dates will be displayed in Column B.

add 30 days to a date with paste special


Method 4 – Adding 30 Days to the Current Date Using the TODAY Function

Steps:

  • In C5, enter:
=TODAY()+30
  • Press Enter to see the output.

add 30 days to current date by using today function


Method 5- Using the WORKDAY Function to Exclude Weekends & Customized Holidays

In Column E, several holidays were added.

Steps:

  • In C5, enter:
=WORKDAY(B5,30,$E$5:$E$9)
  • Press Enter and autofill the entire column to see the output.

add 30 days to a date excluding weekends and customized holidays

Inside the WORKDAY function, the 1st argument is the original date, the 2nd argument the number of days that will to be added or subtracted and the 3rd argument includes the holidays that have to be omitted during the addition.


Method 6 – Using the WORKDAY.INTL Function to Exclude Customized Weekends & Holidays

Steps:

  • In C5, enter:
=WORKDAY.INTL(B5,30,7,$E$5:$E$9)
  • Press Enter and autofill the entire column to see the output.

add 30 days to a date excluding customized weekends and holidays

Read More: How to Add Days to a Date in Excel Excluding Weekends


Method 7 – Embedding VBA Codes to Add 30 Days to a Date in Excel

Step 1:

  • Select the cells containing the dates.

add 30 days to a date with vba editor

Step 2:

  • Press ALT+F11 to open the VBA window.
  • In the INSERT tab, select Module. add 30 days to a date with vba editor

Step 3:

  • In the module, enter the following codes:
Sub Add30Days()

Dim cell As Range
For Each cell In Selection.Cells
    cell.Value = cell.Value + 30
Next cell

End Sub
  • Click  Play or press F5.

add 30 days to a date with vba editor

Step 4:

  • In your Excel worksheet press Alt+F11.

The new dates will be displayed.

add 30 days to a date with vba editor


Download Excel Workbook

Download the Excel workbook here.


Related Articles


<< Go Back to Adding Days to Date | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nehad Ulfat
Nehad Ulfat

NEHAD ULFAT is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET but switched gears, working as a content developer.  In this role, he creates techy content all about Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo