I have a table with work months like here: I'm trying to calculate the start and end datetimes of the month but the formula is giving inconsistent answers. It's correct for some months but there's an error in End Dates for March, May, July, October a...
thanks for your response.timezone matters for me. i'm trying to set the timezone to my timezone that's why I did the minus 7.I don't know why the formula calculates it correctly for some months but not othersI was able to fix it by setting the End Da...
