Hello All,
I have a start date and end date, for an unknown period.
It could be 1 Jan 2021 to 24 Jan 2021 = 24 days
It could be 1 Jan 2021 to 3 June 2021 = XX days
I need to know the count less 30 days, so that the end result does not exceed 30 days.
I have done this with IF Statements, where under 30 = the original date period number of days, which in the above example is 24 days.
But to calculate an unknown period, and know the final number of days which are 30 or below I cannot fathom.
With the IF Statements I have set this for a maximum 4 months period, but it the period extends to 5 or 6 months, then I will need to increase the IF Statement to include this period.
I am sure that there is a simple way of doing this without a multiple IF Statement. Can anyone help me with this?
I have a start date and end date, for an unknown period.
It could be 1 Jan 2021 to 24 Jan 2021 = 24 days
It could be 1 Jan 2021 to 3 June 2021 = XX days
I need to know the count less 30 days, so that the end result does not exceed 30 days.
I have done this with IF Statements, where under 30 = the original date period number of days, which in the above example is 24 days.
But to calculate an unknown period, and know the final number of days which are 30 or below I cannot fathom.
With the IF Statements I have set this for a maximum 4 months period, but it the period extends to 5 or 6 months, then I will need to increase the IF Statement to include this period.
I am sure that there is a simple way of doing this without a multiple IF Statement. Can anyone help me with this?