Hi Folks.
At our local lifeboat station, I have a spreadsheet that is used to record dates across columns to show when crew have completed a specific revalidation task in order to show they have completed the task within an 18 month timeframe.
As its stands, I have about 30 crew members (rows) and across across 10 columns I have a dates in the format DD/MM/YYYY but they are starting to get out of sequence. They should start from January and work across to December but somehow I've got them out of sync. If push comes to shove, I just manually rearrange them all but was just wonder if there was a way of using a formula to sort them in order.
Kind Regards
Declan
At our local lifeboat station, I have a spreadsheet that is used to record dates across columns to show when crew have completed a specific revalidation task in order to show they have completed the task within an 18 month timeframe.
As its stands, I have about 30 crew members (rows) and across across 10 columns I have a dates in the format DD/MM/YYYY but they are starting to get out of sequence. They should start from January and work across to December but somehow I've got them out of sync. If push comes to shove, I just manually rearrange them all but was just wonder if there was a way of using a formula to sort them in order.
Kind Regards
Declan