ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Making sure all dates are accounted for in a sequence (https://www.excelbanter.com/excel-discussion-misc-queries/109832-making-sure-all-dates-accounted-sequence.html)

[email protected]

Making sure all dates are accounted for in a sequence
 
Using Excel 2002, If I have a large spreadsheet with lots of billing
data spanning 12 years is there an automated way to check for missing
months or duplicate months?


[email protected]

Making sure all dates are accounted for in a sequence
 
I used an IF function and it seemd to work well

wrote:
Using Excel 2002, If I have a large spreadsheet with lots of billing
data spanning 12 years is there an automated way to check for missing
months or duplicate months?




All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com