Hi,
In Excel I have a formula to calculate Easter and I need this formula to do in a AMS project, but I can't figure out how to do this.
In Excel the formula would be like this:
Cell A1=1-4-2015
Cell A2=FIXED((A1)/7+MOD(MOD(YEAR(A1);19)*19-7;30)*14%;0)*7-6
That works like a charm, but to port it to AMS
, can you help me?!
Thanks,
Eric
In Excel I have a formula to calculate Easter and I need this formula to do in a AMS project, but I can't figure out how to do this.
In Excel the formula would be like this:
Cell A1=1-4-2015
Cell A2=FIXED((A1)/7+MOD(MOD(YEAR(A1);19)*19-7;30)*14%;0)*7-6
That works like a charm, but to port it to AMS

Thanks,
Eric
Comment