Forum Discussion
How to add the dates using the time criteria ?
Hi Aditya,
Not sure what is the actual problem. In general that could the formula with structured references which will be filled automatically, like
=IFERROR(OFFSET([@Date],-1,0)+IF([@Time]<OFFSET([@Time],-1,0),1,0),DATEVALUE("2016-04-01"))Here we check if next time is less than previous time since your time not always starts from 00:00. Second, in your table dates are not always sequential, e.g. Oct 28, 2017 is right after Oct 26, 2017. Not sure that is mistake or some logic is behind.
Anyway, with structured references not necessary to copy/paste cells, better to use them.
Hi Aditya,
Not sure what is the actual problem. In general that could the formula with structured references which will be filled automatically, like
=IFERROR(OFFSET([@Date],-1,0)+IF([@Time]<OFFSET([@Time],-1,0),1,0),DATEVALUE("2016-04-01"))
Here we check if next time is less than previous time since your time not always starts from 00:00. Second, in your table dates are not always sequential, e.g. Oct 28, 2017 is right after Oct 26, 2017. Not sure that is mistake or some logic is behind.
Anyway, with structured references not necessary to copy/paste cells, better to use them.
- Dear @sergei
Thank you so much for the solution.
Hope I have not asked too much.
Regards,
Aditya