SOLVED

formula doesn't work

%3CLINGO-SUB%20id%3D%22lingo-sub-3003203%22%20slang%3D%22en-US%22%3Eformula%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003203%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20would%20like%20to%20calculate%20the%20number%20of%20days%20between%20February%2015%2C%201949%2C%20and%20Febrruary%2015%2C%202019%2C%20and%20i%20type%20in%20a%20cell%20the%20following%20formula%3A%3C%2FP%3E%3CP%3E%3D%222%2F15%2F19%22-%222%2F15%2F49%22%3C%2FP%3E%3CP%3Ebut%20every%20time%20it%20appear%20me%20the%20message%20%23VALUE%20(see%20the%20screenshot).%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22c1.PNG%22%20style%3D%22width%3A%20926px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329291iA54E3CA257C0F376%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22c1.PNG%22%20alt%3D%22c1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20do%20i%20have%20to%20do%20for%20fixing%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3003203%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3003261%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1228382%22%20target%3D%22_blank%22%3E%40Bn_Rg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DDATE(49%2C2%2C15)-DATE(19%2C2%2C15)%3C%2FP%3E%3CP%3EYou%20can%20enter%20above%20formula.%20However%20i%20would%20enter%20the%20dates%20in%20two%20other%20cells%20and%20calculate%20the%20difference%20as%20shown%20in%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3005095%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3005095%22%20slang%3D%22en-US%22%3Ehi%2C%20thanks%20for%20answering%20me%2C%20unfortunately%20with%20the%20formula%20I%20wrote%20in%20my%20question%2C%20it%20should%20find%20the%20number%20of%20days%20between%20February%2015%2C%201949%20and%20February%2015%2C%202019.%20The%20result%20must%20be%2025567%20days.%3C%2FLINGO-BODY%3E
Occasional Contributor

i would like to calculate the number of days between February 15, 1949, and Febrruary 15, 2019, and i type in a cell the following formula:

="2/15/19"-"2/15/49"

but every time it appear me the message #VALUE (see the screenshot).c1.PNG

What do i have to do for fixing this problem?

4 Replies

@Bn_Rg 

=DATE(49,2,15)-DATE(19,2,15)

You can enter above formula. However i would enter the dates in two other cells and calculate the difference as shown in attached file.

hi, thanks for answering me, unfortunately with the formula I wrote in my question, it should find the number of days between February 15, 1949 and February 15, 2019. The result must be 25567 days.
best response confirmed by Bn_Rg (Occasional Contributor)
Solution

@Bn_Rg 

=DATE(2019,2,15)-DATE(1949,2,15)

 

You can try this formula. It works in my spreadsheet.

Thank you i fix the problem.