Hi all,
I was wondering if someone could help me.
I am trying to count the number of days between dates in certain columns, which I've managed to do successfully to a certain point.., however excel isn't picking up the 'From' and 'To' dates that are the same date as one day, if that makes sense?
This is the formula I've used so far to add each date range together, to then show that total where I've circled below: =DATEDIF(E3,F3,"d")+DATEDIF(G3,H3,"d")+DATEDIF(I3,J3,"d")
The 'Total Days Taken' column needs to be formulated in a way that if someone else uses the spreadsheet it will work it out for them, so their not having to figure out how to change it for certain dates etc.
Appreciate any help, as I'm pulling my hair out trying to understand whether what I'm asking cant be done! ?
I was wondering if someone could help me.
I am trying to count the number of days between dates in certain columns, which I've managed to do successfully to a certain point.., however excel isn't picking up the 'From' and 'To' dates that are the same date as one day, if that makes sense?
This is the formula I've used so far to add each date range together, to then show that total where I've circled below: =DATEDIF(E3,F3,"d")+DATEDIF(G3,H3,"d")+DATEDIF(I3,J3,"d")
The 'Total Days Taken' column needs to be formulated in a way that if someone else uses the spreadsheet it will work it out for them, so their not having to figure out how to change it for certain dates etc.
Appreciate any help, as I'm pulling my hair out trying to understand whether what I'm asking cant be done! ?