Question description:
This user has given permission to use the problem statement for this
blog.
i want to use today() formula to mins from previous date and if cell is empty then come to 0 in cell
Solved by V. Q. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
19/06/2018 - 07:35
Hi
Excelchat Expert
19/06/2018 - 07:35
Welcome to Got it Pro
Excelchat Expert
19/06/2018 - 07:35
Can you please share your excel file to solve your issue
Excelchat Expert
19/06/2018 - 07:36
Are you there?
Excelchat Expert
19/06/2018 - 07:38
As per my understanding just created the data and request you to review and confirm the same
[Uploaded an Excel file]
User
19/06/2018 - 07:45
hi
User
19/06/2018 - 07:45
are you there
User
19/06/2018 - 07:45
actually i have problem
Excelchat Expert
19/06/2018 - 07:45
Hi
User
19/06/2018 - 07:45
can i type in sheet my problem
Excelchat Expert
19/06/2018 - 07:45
Ok. I just created one dummy excel and shared the result..
User
19/06/2018 - 07:45
ok i am writing
Excelchat Expert
19/06/2018 - 07:45
Can you send your excel sheet
User
19/06/2018 - 07:46
sorry its my laptop i am in friend home
Excelchat Expert
19/06/2018 - 07:47
ok no issues
Excelchat Expert
19/06/2018 - 07:47
tell me how can i help you
User
19/06/2018 - 07:48
i just want tthat if my reading column is empty then i want 0 in remarks not any other thing if not empty simple date minus like i already put formula inC4
Excelchat Expert
19/06/2018 - 07:48
yes.. I just fixed it request you to check and confirm
User
19/06/2018 - 07:49
WOW
User
19/06/2018 - 07:49
wow
User
19/06/2018 - 07:49
you are awesome
User
19/06/2018 - 07:49
i need same
Excelchat Expert
19/06/2018 - 07:49
Cool :)
Excelchat Expert
19/06/2018 - 07:49
Is there anything else I need to help you?
Excelchat Expert
19/06/2018 - 07:49
I just used "=if(B4<>"",today()-A4,0)"
User
19/06/2018 - 07:50
i also have an other problem that are same same\
Excelchat Expert
19/06/2018 - 07:50
Ok.. if its completely different problem request you to connect with us again sine we will support one question per session
User
19/06/2018 - 07:50
same like this one
Excelchat Expert
19/06/2018 - 07:50
Ok. Tell me
User
19/06/2018 - 07:53
Dear
Excelchat Expert
19/06/2018 - 07:53
yes . Please tell me
User
19/06/2018 - 07:53
if dis reading is in cell and also rec date in cell then i need reconnected in remarks
User
19/06/2018 - 07:53
and if dis reading cell is empty and also empty rec. Date then i need paid in remarks
User
19/06/2018 - 07:54
and also if rec date is empty then i need disconnected in remarks
Excelchat Expert
19/06/2018 - 07:54
Ok . Let me Check
User
19/06/2018 - 07:54
if u allow me i fill three example there to understand it easy
Excelchat Expert
19/06/2018 - 07:55
Ok. Please take it
User
19/06/2018 - 07:56
i need these three in same sheet
Excelchat Expert
19/06/2018 - 07:56
Ok.
Excelchat Expert
19/06/2018 - 07:59
Just give me 5 minutes
User
19/06/2018 - 08:00
no problem :)
Excelchat Expert
19/06/2018 - 08:04
Are you there with me?
User
19/06/2018 - 08:05
YES
User
19/06/2018 - 08:05
i am here
Excelchat Expert
19/06/2018 - 08:05
Please check the result
User
19/06/2018 - 08:05
Thank you soo much
User
19/06/2018 - 08:05
You are genious
Excelchat Expert
19/06/2018 - 08:05
your welcome :)
User
19/06/2018 - 08:05
Special thanks for you
User
19/06/2018 - 08:05
i am tired from last 2 days
Excelchat Expert
19/06/2018 - 08:05
Request you to provide your valuable feedback and remarks
User
19/06/2018 - 08:06
yes sure
Excelchat Expert
19/06/2018 - 08:06
Request you to connect with us again for any queries and please end the session
User
19/06/2018 - 08:06
my pleasure
User
19/06/2018 - 08:06
sure
User
19/06/2018 - 08:06
thank you boss
Excelchat Expert
19/06/2018 - 08:06
Welcome Boss :)
Excelchat Expert
19/06/2018 - 08:08
Can you please end the session
Excelchat Expert
19/06/2018 - 08:08
If you have any issue please let me know the same.
User
19/06/2018 - 08:09
sir one prob
Excelchat Expert
19/06/2018 - 08:09
yes tell me.
User
19/06/2018 - 08:09
sorry
User
19/06/2018 - 08:09
its no problem
User
19/06/2018 - 08:09
every thing is ok
User
19/06/2018 - 08:09
take care
User
19/06/2018 - 08:09
bye
Excelchat Expert
19/06/2018 - 08:09
Ok cool.
Excelchat Expert
19/06/2018 - 08:09
Bye ! Take care
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.