ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If function calculating date (https://www.excelbanter.com/excel-worksheet-functions/106485-if-function-calculating-date.html)

extrudebg

If function calculating date
 

Return Date $ Recovered
8/14/06


I need some help with a IF calculation. Basically I need a formula
that will calculate this sentence. " If A2 is more than 5 days old
then populate B2 as 0. If A2 is less than 5 days old leave B2 blank."

Any help would be greatly appreciated.

Dennis


--
extrudebg
------------------------------------------------------------------------
extrudebg's Profile: http://www.excelforum.com/member.php...o&userid=37892
View this thread: http://www.excelforum.com/showthread...hreadid=574297


extrudebg

If function calculating date
 

nevermind...figured it out


--
extrudebg
------------------------------------------------------------------------
extrudebg's Profile: http://www.excelforum.com/member.php...o&userid=37892
View this thread: http://www.excelforum.com/showthread...hreadid=574297



All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com