Forum Discussion
EXCEL FORMULA AND FUNCTIONS
Hi All, Anyone can help for the below sample formula and functions as follows: a) =IF(Start Date > Last Day of Year,0,(Amended End Date - Amended Start Date)/365) b) Amended End Date = IF(E...
Your post has (at the moment of writing) 69 views and 0 replies, perhaps because it's difficult to understand.
- Last Day of Year - which year?
- Your example has Inception Date - is that the same as Start Date?
- Your example doesn't show Amended Start Date and Amended End Date.