You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello, I'm trying to use a formula, with a number formatted as currency, as the second argument in the edate function. Numbers doesn't seem to be able to deal with this. When I change the format in question to number, edate works. Formt that column back to currency and edate fails. Any suggestions are welcome. Thanks.
MacBook Pro 13", macOS 10.15
Hi PhilipH56,
TRUNC worked for me
EDATE("12/30/19",TRUNC(H3,1))
quinn
Hi PhilipH56,
TRUNC worked for me
EDATE("12/30/19",TRUNC(H3,1))
quinn
That works. Thanks, Quinn!
The rounding functions also solve the problem.
Using a currency in the second argument of emonth
