Replicating an Excel formula in Access?
I'm trying to import some Excel data into Access. I have one column in my Excel spreadsheet that performs a calculation on two date cells. For example: Excel cell D1 has a date value, for this example, let's use a date of 01-01-1990 (i.e., Jan 1, 1990). Excel cell D3 has a date value of any date after the date entered in A1, let's use 9-8-2021 (Sept 08, 2021). Excel cell D5 has a formula: =DATEDIF($D$1,D3,"y") & "-" & DATEDIF($D$1,D3,"ym") & "-" & DATEDIF($D$1,D3,"md") When using the above example dates entered in D1 & D3 yields a display in D5 of: 31-8-7 i.e., 31 years, 8 months, 7 days, showing the calculation of time (in terms of years, months days) between the two dates. Can I import this functionality into Access? If so, how is this done? Idealy I'd like the Access field to be calculated and displayed as: 31Y, 08M, 07D but I'll take anything I can get.