Fund Manager
Contact Us

Days Between Formula

Questions on using, creating, or understanding data in Fund Manager reports.

Postby AssetHound » Fri Jan 06, 2023 4:28 pm

I'd like to create an IF statement that checks for the number of days between the starting and ending report dates, and calculate an expression based on whether or not the report period length is over/under a fixed number of days. The usage of EVAL and other days functions aren't clear to me, however. Thanks for any help.
Posts: 57
Joined: Sun Sep 11, 2011 3:14 pm

Postby Mark » Fri Jan 06, 2023 5:07 pm

Hi AssetHound,

You can use something like:

IF((ENDDAYS()-STARTDAYS()) > 30, 1, 0)

so, if the date range of the report is more than 30 days, it will return 1, and if not, it will return 0. You can replace 1 and 0 with your desired expressions, and you can of course change 30 to whatever you wan.
Fund Manager - Portfolio Management Software
Site Admin
Posts: 11215
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Return to Reports

Who is online

Users browsing this forum: No registered users and 3 guests | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.