Feb 14 2022 08:56 AM - edited Feb 16 2022 07:17 AM
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?
Feb 14 2022 09:09 AM
Which negative values do you mean.
Enter 5000 and apply any format you wish, in particular that could be currency format.
Feb 15 2022 02:01 AM
Feb 15 2022 02:09 AM
Feb 15 2022 02:20 AM
Feb 15 2022 06:29 AM
Screenshot doesn't show what you are doing. You may have another regional format and use texts which looks like dates instead of dates. Cell which looks like blank could be not blank but have empty text. Whatever. If you open my file and it works compare with your one and try to find the difference.
You may attach your file replying on post
If that functionality is not available sent it to me by Direct Message, it shall work in any case.
Feb 15 2022 08:07 AM
Feb 15 2022 08:15 AM
Feb 15 2022 08:53 AM
Feb 15 2022 10:05 AM
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
Feb 15 2022 11:22 AM
I see only pdf and another screenshot, but not the Excel file
Feb 15 2022 11:23 AM
I guess the question is not which formula to use, but how to work with Microsoft tutorial
Feb 15 2022 12:23 PM
Feb 15 2022 12:54 PM
Feb 15 2022 11:13 PM
Feb 16 2022 06:13 AM
Feb 16 2022 06:22 AM
Feb 16 2022 06:28 AM
Feb 16 2022 07:01 AM
Feb 16 2022 07:14 AM - edited Feb 16 2022 07:19 AM
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.