# How to Minus Number of Days or a Date from Today in Excel

Get FREE Advanced Excel Exercises with Solutions!

Determining the days between dates is a very common use of Excel. If you are curious about how you can calculate the subtraction of days or dates from Todayâ€™s date, then this article may come in handy for you. In this article, I am going to show how you can minus a number of days or dates from Todayâ€™s date in Excel with an elaborate example.

## How to Minus Number of Days or a Date from Today in Excel: 3 Suitable Examples

We are going to show three separate examples of subtracting the days from todayâ€™s date. Before using them, make sure that the dates are actually in the right format. To avoid any kinds of compatibility issues, try to use the Excel 356 version.

### 1. Subtract Number of Days from Today

Here, in this example, we are going to subtract/ delete different day values from Todayâ€™s date using the TODAY function.

Steps

• We have the number of days that are going to be deleted from todayâ€™s date.
• To do this, select cell C5 and enter the below formula:

`=TODAY()-B5`

• Then drag the Fill Handle to cell C11.
• Doing this will fill the range of cells with todayâ€™s date subtracted by the days mentioned in the range of cells C5:C11.

### 2. Subtract Number of Days from Today with Paste Special Method

Using the paste special tool, we can delete a certain amount of days from todayâ€™s date.Â  We are going to use the TODAY function to accomplish this.

Steps

• For starters, you need to enter Todayâ€™s date.
• Select cell C5 and enter the formula below:

`=TODAY()`

• Select cell C5 and right-click on it.
• From the context menu, click on the Copy.

• Then again return to cell B5 and right-click on the mouse again.
• Then from the Context menu, go to Paste Special > Paste Special.

• In the new window named the Paste Special, Select Values under the Paste
• And then select Subtract under the Operation
• Click OK after this.

.

• After clicking You are going to see that Todayâ€™s date is subtracted by values mentioned in cell C5.

### 3. Calculate Number of Days Between Today and Another Date

In this, the difference between the two dates is going to be calculated using the TODAY and DAYS formula.

Steps

• Now we have the random dates in the range of cells C5:C10. The days between these dates and todayâ€™s date are going to be calculated.
• To calculate the number of days between todayâ€™s date and another date, we need to determine todayâ€™s date.
• To do this, select the cell B5 and enter the following formula:

`=TODAY()`

• Moreover, merge the range of cells B5:B10.

• To calculate the days between Todayâ€™s date and the random dates enter the following formula:

`=DAYS(B5,\$C\$5)`

• Then drag the Fill Handle to cell D10.
• Doing this will fill the range of cells with the day differences between todayâ€™s date and the random dates.

## ðŸ’¬ Things to Remember

If any value seems odd or out of format, then try to reformat it. For example, if the value shows number format instead of date format, then reformat the cell from the Home menu.

## Conclusion

To sum it up, the issue of how we minus date or days from todayâ€™s date is shown here with 3 separate examples.

For this problem, a workbook is available to download where you can practice these methods.

Feel free to ask any questions or feedback through the comment section.

<< Go Back to

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Md. Abdullah Al Murad is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find... Read Full Bio

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..

• Hello, IMTIYAZ AHMED!
Regarding your question, are you saying that your machine breakdown continues daily from 6:00 AM to 4:00 PM and now you want to calculate total machine breakdown hours as 10 hours every day till 15/1/2021? Is it what you have asked for?
Or something else? Please make your question a bit more clear. We are eager to get your reply to provide you with the actual solution to your query.
Regards,
Tanjim Reza

Advanced Excel Exercises with Solutions PDF