How to Subtract/Minus Days from Today’s Date in Excel (4 Simple Ways)

Subtracting Days To Date With Formula

We need to do project scheduling and time management for various purposes. For that, we can use MS Excel for calculating dates. This article will show you how to subtract/Minus days from today’s date in Excel.

Download the Practice Workbook

4 Ways to Subtract/Minus Days from Today’s Date in Excel

1. Subtracting Days To Date With Formula

We can subtract dates from any dates using a simple subtraction formula in Excel. For this, let’s consider we have some dates, and we will figure out the dates before 20 days.

Subtracting Days To Date With Formula

Step 1: Enter the formula<span style="white-space: pre-wrap;"> =B4+20 </span>in cell C4.

 Enter the formula =B4+20 in cell C4

Step 2: Copy down the formula up to C10.

Copy down the formula up to C10

2. Subtracting Days from Date Using DATE Function

The DATE function is another way to subtract a day, month, a year from any date. Let’s consider the same example above, but now we will subtract 20 days from the given date using the DATE function. The function syntax is like this:

<span style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black;">= DATE(YEAR(date), MONTH(date), DAY(date)-(no. of days to be subtracted))</span>

For this method, we will consider the day parameter of the DATE function. Other parameters will be unchanged here. 

Step 1: Enter the formula =DATE(YEAR(B4), MONTH(B4), DAY(B4)-20) in cell C4 and press the Enter key.

Date function parameter

Step 2: Copy down the formula up to C10.

Copy down the formula up to C10

3. Subtracting Days To Date Without Formula (Paste Special)

We will do the same task mentioned in method one but without a formula. We will use the Paste Special option where the procedure is not required.

Subtracting Days To Date Without Formula

Step 1: Right-click on cell D4 and select copy or use keyboard shortcut Ctrl+C

Right click on cell D4 and select copy or use keyboard shortcut Ctrl+C

Step 2: Select the date cells that you want to subtract and Right-click on them. Then select Paste Special

 Select the date cells that you want to subtract and Right click on it. Then select Paste Special

Step 3: Then follow the steps:

  1. Select the Values option.
  2. Then select the Subtract option.
  3. Lastly, press the OK button.
    Paste Special Steps

Step 4: Then all the previous dates will be changed will change all the dates like this.

 Paste Special result

Now our dates are changed like this using the Paste Special option.

Converted After paste special

4. Using Function TODAY to Subtract/Minus Dates from Today’s Date 

Sometimes we may need to calculate the total days from any specific dates. This way, Excel helps us by providing another function that is TODAY. For example, let’s consider a dataset of some employee’s joining dates. Now we will calculate the total working dates up to today.

Using TODAY Function to Subtract or Minus Dates From Today's Date

Step 1: Enter the formula <span style="white-space: pre-wrap;">=TODAY()-C4</span> in cell D4.

Enter the formula =TODAY()-C4 in cell D4

Step 2: Copy down the formula up to D9.

Copy down the formula up to D9

Step 3: Now, convert the dates into days by following the process. 

  1. Go to the Home tab.
  2. Then go to the Number section.
  3. Select the Number option.

     Now convert the dates into days by following the process

Step 4: Then, all the days from the joining dates will be calculated up to today.

Then all the days will be calculated up to today

➥ Related: Excel Formula to Calculate Number of Days Between Today & Another Date 

Downloadable Day Subtractor Calculator

For your practice, here is the day subtractor calculator. With this, you can calculate the remaining dates up to today. This workbook is fully customizable, and all the instructions are provided in this file for better understanding.

Conclusion

These are the ways to do day subtraction from any dates in Excel. Here I have discussed different ways with relevant examples step by step. I hope these methods will help you to resolve this type of issue. Please inform us if you’ve any difficulties using these methods.


Further Readings

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

1 Comment
  1. hi, i need to substract dates formula of machine break down hours
    i.e : machine breakdown started A1:1/1/2021 B1: 6:00 am

    job done C1: 15/1/2021 D1: 4:00 PM

    with minimum 10 hours each day = 150 hours(15 days)

    can some one help me out on this formula..

Leave a reply

ExcelDemy
Logo