Quantcast
[ 3 / biz / cgl / ck / diy / fa / g / ic / jp / lit / sci / tg / vr ] [ index / top / reports / report a bug ] [ 4plebs / archived.moe / rbt ]

2017/01/28: An issue regarding the front page of /jp/ has been fixed. Also, thanks to all who contacted us about sponsorship.

/g/ - Technology


View post   

[ Toggle deleted replies ]
File: 2.10 MB, 3038x1646, 20190415_135249(1).jpg [View same] [iqdb] [saucenao] [google] [report]
70566541 No.70566541 [Reply] [Original] [archived.moe] [rbt]

Please help me out in my retardation. I'm simply trying to subtract the number of days between the date in a cell and today. It keeps displaying a date in 1900 instead. I tried the DAYS function too. Same result. Everything online says it should work. What gives?

>> No.70566567

Check the D column formatting - it might be set to show the returned number as a date instead of, well, a number.

>> No.70566605

(so the formula is correct, but the output cells in column D are interpreting the result - eg '3' - as a date. as in, 3 days from the start of 1900, thus displaying 01/03/19)

...I think

>> No.70566650
File: 162 KB, 2286x1470, Annotation 2019-04-15 220549.png [View same] [iqdb] [saucenao] [google] [report]
70566650

Like this, OP.

>> No.70566654
File: 1.23 MB, 788x654, Screenshot_2019-04-15-14-05-51(1)(1).png [View same] [iqdb] [saucenao] [google] [report]
70566654

>>70566567
Thanks smart friend

>> No.70566661

>>70566650
And thank you as well. I knew i could count on /g/

>> No.70566716

>>70566654
>>70566661
No problem; payment is via the usual method. I've sent you the details. Make it look like an accident

>>
Name (leave empty)
Comment (leave empty)
Name
E-mail
Subject
Comment
Password [?]Password used for file deletion.
reCAPTCHA
Action