Hi,
I have a ‘date’ type column called [LMP]. I am trying to add 9 months and 7 days to the date in LMP column and return the resulting date to another column called [EDD]. Is it possible to do this? Since different months have a different number of days, what I want is for the app to figure out which month the LMP column has and based on that month, add 9 months and 7 days to that and bring out the date for the [EDD] column. Would appreciate your help on this.
Thanks.
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |