Hi,

I am trying to round any date in a series that doesn’t exist (e.g if 31st doesn’t exist in month, round down to 30, if it’s 31st in Feb, round down to 29, etc) in a month down. 

Ex (Array 1):

2024-02-31

2024-04-31

2024-08-31

2024-09-31

Formula should output the following from Array 1 (e.g rounding down to closest date):

2024-02-29

2024-04-30

2024-08-31

2024-09-30

Any ideas on how this can be done? My thanks in advance.

​Hi, I am trying to round any date in a series that doesn’t exist (e.g if 31st doesn’t exist in month, round down to 30, if it’s 31st in Feb, round down to 29, etc) in a month down.  Ex (Array 1):2024-02-312024-04-312024-08-312024-09-31Formula should output the following from Array 1 (e.g rounding down to closest date):2024-02-292024-04-302024-08-312024-09-30Any ideas on how this can be done? My thanks in advance.  Read More

​