| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in excel using date criteria
I'm trying to formulate a cell where the criteria is as follows;
=IF(A1+365+365-1)<01/01/07,"Asset Fully Depreciated","??/??/??") A1 = Acquisition date... and (A1+365+365-1 would arrive at 31Dec06 - implying a 2yr life for an asset) So what I'm trying to say is that is the asset has expired after it's 2yr life, then I want it to say "Asset fully depreciated", otherwise, I want it give me the date at which 2 years expires. Am I asking too much from excel? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
| how to use lookup a value by date for criteria in Excel sheet | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
| Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Threaded Mode
