LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default don't calculate if no date is entered


If(d2 = 0; 0; Days360(d2,today()))


--
darkxer0x
------------------------------------------------------------------------
darkxer0x's Profile: http://www.excelforum.com/member.php...o&userid=35967
View this thread: http://www.excelforum.com/showthread...hreadid=557567

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate a date or key a date on condition Tolo Excel Discussion (Misc queries) 2 June 13th 06 04:16 PM
Calculate 1st of month date from existing date. Jim15 Excel Discussion (Misc queries) 1 January 9th 06 10:05 PM
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM
formula to calculate future date from date in cell plus days Chicesq Excel Worksheet Functions 8 November 3rd 05 12:25 PM
How can I calculate the week number from a date, eg 21/06/05 = 26 cel504 Excel Worksheet Functions 2 August 3rd 05 08:14 PM


All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"