Convert a Excel formula to Access expression

[Dana5535]

I have an excel spreadsheet formula that calculates the percentage of time that has elapsed for a contract.

The excel formula is =(Today()-A38)/(B38-A38) . A32 represents the starting date of the contract and B38 represents the ending date of the contract.

Is there a way to convert this formula to an expression in Access?

I am still learning Access 2010, so any help will be appreciated.

Thanks,

 

[Joe4]

Welcome to the Board!

Just use DATE() instead of TODAY(), and your field names in place of your cell references.
The structure should be exactly the same.

 

[Dana5535]

Welcome to the Board!

Just use DATE() instead of TODAY(), and your field names in place of your cell references.
The structure should be exactly the same.

Thanks for the info. I tried that and didn't get what I expected. When I use the excel formula using this formula: =(TODAY()-A48)/(B48-A48) Today is today's date, A48 =2/2/15 and B48 = 2/3/17 the result is 7.79%. However when I use this express in access (Date())-[Validfrom]/[Validto]-[Validfrom], Validfrom = 2/2/15 and Validto = 2/3/17, I get this result: 56.0171152002586

I thought it should work that way also, but now I'm confused.

Thanks.

 

[Joe4]

It appears to be an mathematical "order of operations" issue. Parentheses are very important, don't drop them (or move them around), if you want the formula to work the same way.

The equivalent of:

[COLOR=#333333]=(TODAY()-A48)/(B48-A48)[/COLOR]

would be:

[COLOR=#333333](Date()-[Validfrom])/([Validto]-[Validfrom])[/COLOR]

 

[Dana5535]

Joe, this looks like it will work, so simple. I just missed it. Thank you for the help, extremely grateful!

 

[Joe4]

Excellent! Glad to help!