Forum

Notifications
Clear all

Dates format 1900

4 Posts
3 Users
0 Reactions
70 Views
(@dejo)
Posts: 5
Active Member
Topic starter
 

Hello,
I have problem with format table when I use automatically inputs for dates by formula.

I have submit excel, its problem in cell B:
=IF([@Mašina]"";IF([@[Dates input formula]]="";NOW();[@[Dates input

When I use only formula =now() dates are showen ok.

Please some help.

Tnx in advance

 
Posted : 04/01/2023 2:43 am
Riny van Eekelen
(@riny)
Posts: 1191
Member Moderator
 

If you tried to upload a file to demonstrate the problem, please try again and don't forget to press "Start upload" before you submit your reply.

 
Posted : 04/01/2023 1:23 pm
(@dejo)
Posts: 5
Active Member
Topic starter
 

Sorry, here it is...
tnx

 
Posted : 05/01/2023 2:29 am
(@debaser)
Posts: 836
Member Moderator
 

You've created a circular reference by putting that formula in the same column it is referring to. What are you actually trying to achieve?

 
Posted : 05/01/2023 5:59 am
Share: