Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting days formula
Here is the formula I use: =DATEDIF(B6,TODAY(),"D") to calculate # of days from date I entered. However when I left the cell blank, it gives it a value of 38607. How can I get it blank if I don't enter a date? It affect the whole spreadsheet. Thanks. -- cardingtr ------------------------------------------------------------------------ cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027 View this thread: http://www.excelforum.com/showthread...hreadid=467031 |
#2
|
|||
|
|||
Hi
=IF(B6="","",DATEDIF(B6,TODAY(),"D") or =IF(B6="","",TODAY()-B6) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "cardingtr" wrote in message ... Here is the formula I use: =DATEDIF(B6,TODAY(),"D") to calculate # of days from date I entered. However when I left the cell blank, it gives it a value of 38607. How can I get it blank if I don't enter a date? It affect the whole spreadsheet. Thanks. -- cardingtr ------------------------------------------------------------------------ cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027 View this thread: http://www.excelforum.com/showthread...hreadid=467031 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vacation Accrual Formula | Excel Worksheet Functions | |||
formula for counting charachters in a cell ? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula for # of sales days in a month? | Excel Worksheet Functions | |||
selecting days of week using a formula in spreadsheets | Excel Worksheet Functions |