Applies to: @RISK models with or without MPP files

Using Dates with @RISK Functions in Excel

Issue:
When using a literal date in RiskTarget or RiskXtoP (e.g., RiskTarget(F2, 8/12/2017)), @RISK may return 0 even if your distribution spans that date.

Cause:
Excel interprets 8/12/2017 as a division (8 ÷ 12 ÷ 2017) instead of a date, producing a numeric value near 0 (29 seconds past 1 Jan 1900). @RISK then calculates the percentile for that number, resulting in 0.

Solution:
Use the DATE function to pass dates correctly:

RiskTarget(F2, DATE(2017,12,8))
RiskXtoP(F2, DATE(2017,12,8))

• Format: DATE(year, month, day)

• Works consistently across locales; in non-English Excel, DATE may have a different name (e.g., FECHA in Spanish).

Tip: Use Microsoft’s Excel Functions Translator add-in for translating function names in different languages.