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?
And also, how can I type $ 5,000.00 in a table to sum up among other constants?
19 Replies
- What exactly shall I drop? I had it open on my phone too, can I drop it there?
- Don't know, I don't have an iphone...
if you don't try it, you don't know either :)).
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?
Which negative values do you mean.
Enter 5000 and apply any format you wish, in particular that could be currency format.
- I have now added a picture in my post about negative values when I typed "=Today()". I could type
$ 5 000.00, but not $5,000.00, like someone had done in a tutorial.
