ExcelBanter - Display another Cell's DATE value Here

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Display another Cell's DATE value Here (https://www.excelbanter.com/excel-discussion-misc-queries/115617-display-another-cells-date-value-here.html)

Michell Major

Display another Cell's DATE value Here

I have 4 date cells A1, B1, U1 and V1. If U1 and V1 have a date in them how
can that date be transferred/displayed to B1 if, and only if, B1 is void??

All times are GMT +1. The time now is 12:51 PM.