If your dates are sequential and in column A, in a helper column starting with row 2, put in this formula =if (A1+1=A2,"","Missing Date") and copy it down.
Alan
If your dates are sequential and in column A, in a helper column starting with row 2, put in this formula =if (A1+1=A2,"","Missing Date") and copy it down.
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks