subtract number of days from the date

**tabkaz** · 02-08-2018, 09:53 AM

I have to subtract days from a Start date

tried using the different function but couldn't find the solution.

start end Result Days description
1-Feb 16-Feb 12 12 subtracts 12 days from start date (1st feb)

**CK76** · 02-08-2018, 09:56 AM

Can't you just use =B2-E2 ?

Which gives 20-Jan as result.

**tabkaz** · 02-08-2018, 10:00 AM

thanks for looking into it... basically I want a result in whole number format, not in a date format.

**CK76** · 02-08-2018, 10:08 AM

... so what's the expected result when you subtract 12 days from 1-Feb?

subtract number of days from the date

LinkBack

Thread Tools

Rate This Thread

Display

subtract number of days from the date

Re: subtract number of days from the date

Re: subtract number of days from the date

Re: subtract number of days from the date

Thread Information

Users Browsing this Thread

Similar Threads

How can I automatically subtract a number based on previous 90 days (attendance tracker)

[SOLVED] How to subtract two dates to calculate the number of days between them?

[SOLVED] Subtract Two Dates By The Number of Days, But Only Inlcude Work Days

[SOLVED] Excel 2007 : Subtract date from a current date and show difference in months and days

Subtract Days from Date.

Subtract # of days from date, but if not sat, goto previous sat?

Subtract number of Working Days

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions