I currently have a date range manually typed into the following box taken from a single cell (A) which runs every day.
Is there a formula that I can use that this box automatically populates when I enter new dates going forward?
CodePudding user response：
Depending on where the two dates are placed, it would be like:
=TEXT(A1,"dd-mmm-yy") &" - "& TEXT(B1,"dd-mmm-yy")
where the first date is in A1 and second date is in B1.
If you are wanting to produce a text output that shows a From-To based on the chronologically first and last date in Col A, then:
=TEXT(MIN(A:A),"dd-mmm-yy") &" - "& TEXT(MAX(A:A),"dd-mmm-yy")