Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
103
Views
I am struggling to get the right formula right for the following please:
Column K = recent dates
Column V = date of birth
Column BH = =(K minus V divided by 365) ...to give age
Sometimes column V is not populated so BH gives the error #value
How do I add an IFBLANK or similar so that if V is empty then it puts a Zero as the result please?
Thanks
Posted : 21/05/2022 8:01 am
Hi Gill,
Welcome to our forum!
Try this where your data is in row 2:
=IF(V2="",0,(K2-V2)/365)
Or
=IFERROR((K2-V2)/365,0)
Mynda
Posted : 21/05/2022 7:00 pm