Formula needed to count the number of days based on a date in other cells

**excelteam777** · 10-04-2019, 06:47 PM

WS attached

I need a simple formula to count the number of days between a date entered in another cell and the current date. This number should change as days pass and ws is reopened.

Formula goes in B2:B10
The date inputted into A2:A10 will populate in B2:B10 and count the number of days from the date entered through whatever the current date is.

**alansidman** · 10-04-2019, 06:53 PM

In B2, =DATEDIF(A2,TODAY(),"d") and copy down.

**menem** · 10-05-2019, 01:35 AM

You may use this formula

B2
=TODAY()-A2
and format the cell as general number.

Regards.

**excelteam777** · 10-05-2019, 09:40 AM

works great thank you

**excelteam777** · 10-05-2019, 09:59 AM

the only problem is when I dont have a date entered it shows an error amount of 43473. Can you adjust the formula not to show error codes when no data is available?

**alansidman** · 10-05-2019, 10:17 AM

43473 is the date. Is the number of days since 1/1/1900. Just reformat it as a date to see in the style you wish.

**excelteam777** · 10-05-2019, 05:40 PM

No, the B column is where it populates the number of days from the date entered into the A column and the current date. Currently when I enter a date into A column it shows correctly the number of days in the B column. But when nothing is entered into the A column it shows 43473.

**menem** · 10-05-2019, 10:29 PM

Try

=IF(A2>0,TODAY()-A2,"")

Regards.

**excelteam777** · 10-06-2019, 11:49 AM

got it thanks again

Formula needed to count the number of days based on a date in other cells

LinkBack

Thread Tools

Rate This Thread

Display

Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Re: Formula needed to count the number of days based on a date in other cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Simple formula needed to count cells based on item names in other cells

[SOLVED] Count the number of days in the year to date less the days in the current month

[SOLVED] highlight a series of cells based on the number of days in a date range

How do i write a formula to count the number of days in a date range, split per month

[SOLVED] Formula Needed to count based on entries into 2 other cells.

[SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells

How do I count the number of people needed on a project over various days?

Bookmarks

Bookmarks

Posting Permissions