Count Days Between an Event

[tdpalmer]

In column A is a Julian date. Column B has a 1 if there was an event and blank if there was not an event.

I would like to count the days between the occurrence of the events. The calculation will need to be done on the date column because the data is sometimes missing days.

Thanks in advance.

 

[Special-K99]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[tdpalmer]

Will do.