Calculate how many days to your birthday!

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3163947%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECalculate%20how%20many%20days%20to%20your%20birthday!%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3163947%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi!%20I%20think%20I%20followed%20the%20instructions%20but%20I%20got%20an%20error%20message.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348057iA9F5E17E2B9D344A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Jorgen980_0-1644852166501.png%22%20alt%3D%22%5C%26quot%3BJorgen980_0-1644852166501.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20from%20the%20tutorial%20in%20Windows%2011.%20First%20it%20shows%20negative%20values%2C%20and%20then%20maybe%20if%20was%20too%20late%20to%20delete%20that%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3163947%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3163947%22%20slang%3D%22en-US%22%3ECalculate%20how%20many%20days%20to%20your%20birthday!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3163947%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20think%20I%20followed%20the%20instructions%20but%20I%20got%20an%20error%20message.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jorgen980_0-1644852166501.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348057iA9F5E17E2B9D344A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jorgen980_0-1644852166501.png%22%20alt%3D%22Jorgen980_0-1644852166501.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20from%20the%20tutorial%20in%20Windows%2011.%20First%20it%20shows%20negative%20values%2C%20and%20then%20maybe%20if%20was%20too%20late%20to%20delete%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3163947%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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

@Jorgen980 

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.

@Jorgen980 

Without file it's hard to say what is wrong. It shall be

image.png

Please check in attached file.

What file do you want? Type how I can share it to you. I don't understand what you are showing with your attached file. Looks like mine. Could you do a video?

@Jorgen980 

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

image.png

If that functionality is not available sent it to me by Direct Message, it shall work in any case.

@Sergei Baklan 

 

I dont think your file worked. The first line showed #########.

@Jorgen980 

Please select column

image.png

and make it wider

image.png

See if you can find my file now.

@Jorgen980 

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

 

NikolinoDE

@Jorgen980 

I see only pdf and another screenshot, but not the Excel file

@NikolinoDE 

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?

@Jorgen980 

Same way as you attached file to this post

image.png

or as you attached pdf to the initial post

@Jorgen980 

 

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
 
Maybe it will help as a reminder
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 :)).

I now have the excel file open and this chat on a splitted screen. Excel has a share button but then I need to know his email. I can't find anything to drag in her from that document. There is no address. Have you ever drag an excel file into a chat like this?
Could you please describe the procedure, all the steps/actions, that I need to take?

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.