ExcelBanter - View Single Post - using date function, month shows as January when i type (12)

Thread: using date function, month shows as January when i type (12)

View Single Post

#2

Report Post

Dave O

Posts: n/a

Default

Does this formula do what you need?
="12/31/"&YEAR(A1)+19

Reply With Quote

Reply With Quote