I have attached my spreadsheet------On sheet2 (DUE LIST) that is pulled from sheet1, there are some cells in column F that need to be Date format, basically if column H has an M (stands for months) ---i need column F same row to be date format---if anyone can help it would be much appreciated--thanks in advance------Also, I cant just set up sheet2 with correct formats in the cells because its a constantly changing sheet.
Bookmarks