Forum Discussion
Calculate how many days to your birthday!
Hi! I think I followed the instructions but I got an error message. This is from the tutorial in Windows 11. First it shows negative values, and then maybe if was too late to delete that? ...
With everyone's permission, here's another approach, with two cells.
=IF(A1,DATE(YEAR(A1)+DATEDIF(A1+1,TODAY(),"y")+1,MONTH(A1),DAY(A1))-TODAY(),"")
If it doesn't help, please just ignore it.
File with example added
I guess the question is not which formula to use, but how to work with Microsoft tutorial
- Maybe both. Could you please tell me how to share the excel file with you?
https://1drv.ms/x/s!AqvpaLjMp1_pgXiBGCXe8MEjRGFG
I copied the link. A copy is in my first message too. I think you need to download it.
