ExcelBanter - Networkdays

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Networkdays (https://www.excelbanter.com/excel-worksheet-functions/267499-networkdays.html)

pancho

Networkdays

I can get the number between 2 dates. However if one date is not known (B1) and it stays 0. How do I get the date entered (A1) subtract from the spreadsheet date to get the number of current days.

A1 = Jan 12, 2010
B1 = July 18, 2010
C1= # of days between

Mazzaropi

Quote:

Originally Posted by pancho (Post 961360)

-------------------------------------------------------------------------

Dear Pancho, Good Morning.

Try this one: =IF(B1="",TODAY()-A1,B1-A1)

Tell me if it worked for you.

All times are GMT +1. The time now is 03:52 PM.