Forum Discussion
washpv1219
Dec 14, 2017Copper Contributor
If Statement in Excel
I am trying to create this formula in a column to do two functions. I have columns B and I set to be filled with dates. I also have column J set to calculate the number of days between those 2 dates....
SergeiBaklan
Dec 14, 2017Diamond Contributor
Hi,
Please remove "=" before TODAY(). Bit shorter
=IF(I2="",TODAY(),I2)-B2