**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.*