Dazzybeeguy
Board Regular
- Joined
- Jan 6, 2022
- Messages
- 72
- Office Version
- 365
- 2010
- Platform
- Windows
Hi
I you have a calculation to work out the number of days between 2 dates i.e. =IF(G11>0,G11-G10,"")
Is there a way to write it so that if the two dates are the same date to return a value of 1 instead of 0 ?
TIA
I you have a calculation to work out the number of days between 2 dates i.e. =IF(G11>0,G11-G10,"")
Is there a way to write it so that if the two dates are the same date to return a value of 1 instead of 0 ?
TIA