Forum Discussion
Deleted
Jun 19, 2018Excel Formula issue
I am using Excel 2016. I am creating a birthday spreadsheet. I have an Age column in which the formula is calculated upon the current date which is cell J1 and the date of birth which is column D. My...
- Jun 19, 2018You need to wrap your DATEDIF in a IF, see here for a example:
https://www.mrexcel.com/forum/excel-questions/541600-if-statement-datedif.html
Peter Stilgoe
Jun 19, 2018Iron Contributor
You need to wrap your DATEDIF in a IF, see here for a example:
https://www.mrexcel.com/forum/excel-questions/541600-if-statement-datedif.html
https://www.mrexcel.com/forum/excel-questions/541600-if-statement-datedif.html
Deleted
Jun 19, 2018Thank you Peter. Your solution worked. Very much appreciated.