sangeeta25
Board Regular
- Joined
- Jun 15, 2015
- Messages
- 59
Hi everyone!
I need help with a formula to do the following action below...
I have column A which says "date in" and column B which says "date out" and then column C which says "number of days"
So what I would like to have is when someone puts in a date in say cell a3, the date being 14/05/2016 and then puts in a date (for date out) in cell b3, the date being 17/05/2016, I would then like for cell C3 to count the days between cell a3 and b3 including the day in a3, so c3 will automatically calculate the number 4 because between the 14th and 17th including the 14th is 4 days.
Can someone please assist?
Thank you in advance!!!
S
I need help with a formula to do the following action below...
I have column A which says "date in" and column B which says "date out" and then column C which says "number of days"
So what I would like to have is when someone puts in a date in say cell a3, the date being 14/05/2016 and then puts in a date (for date out) in cell b3, the date being 17/05/2016, I would then like for cell C3 to count the days between cell a3 and b3 including the day in a3, so c3 will automatically calculate the number 4 because between the 14th and 17th including the 14th is 4 days.
Can someone please assist?
Thank you in advance!!!
S