Try this formula in B5
=IF(ISERR((ROWS(B$5:B5)&B$1&C$1)+0),"",(ROWS(B$5:B5)&B$1&C$1)+0)
format in required date format and copy down to B35
Try this formula in B5
=IF(ISERR((ROWS(B$5:B5)&B$1&C$1)+0),"",(ROWS(B$5:B5)&B$1&C$1)+0)
format in required date format and copy down to B35
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks