Forum Discussion
Tom3112
Feb 03, 2023Copper Contributor
Isblank and today function
Hi, Wondering if someone can help I am using the today function to to calculate how many days has elapsed from a certain date My dates are in Cells A3 - A99 and the answer of how how many...
- Feb 03, 2023
=IF(ISBLANK(A3),"",TODAY()-A3)
Riny_van_Eekelen
Feb 03, 2023Platinum Contributor
=IF(ISBLANK(A3),"",TODAY()-A3)
Tom3112
Feb 03, 2023Copper Contributor
Riny_van_Eekelen legend thanks mate worked perfect