Subtract a date from a Date and get remaining Days

[Softwarez]

How can i subtract a date form a date in excel?

Not VBA code, just normal excel please !

Heres my scnario.. (what i thought i could do)

I had a cell with =Today() 'Gives todays date

then a cell with a "Due Date" A day my assignment is due.

So i then wanted to get how many days till the assignment was due.

So i thought..

Say due date was E3
and =Today() was F3

=SUM(E3-F3)

but i get #VALUE!


any ideas? thanks.

 

[barry houdini]

just

=e3-f3

 

[jdee]

I just tried what you have stated and if I format the result cell as number it works as expected. IE subtrating Due date from start date shows number of days.

 

[barry houdini]

If you get a #VALUE! error that probably means that either E3 or F3 is being interpreted as text.

does

=E3-today() work?

 

[Softwarez]

Nope.. neither works.. im still getting #VALUE! how weird... =/..

 

[SteveO59L]

When you get it to work, remember to add 1 day.

i.e today()-today() = 0, your desired result should be 1

 

[barry houdini]

Nope.. neither works.. im still getting #VALUE! how weird... =/..

what's in E3?

try =ISNUMBER(E3) do you get TRUE or FALSE?

 

[Softwarez]

Ah i found out why.. i have a calendar on ym userform which puts the date in a textbox which then puts it to the sheet.. however... it puts a space infront of the date making it invalid!! how can i get ri dof the space? =/ it seems to put it there standard

 

[just_jon]

Ah i found out why.. i have a calendar on ym userform which puts the date in a textbox which then puts it to the sheet.. however... it puts a space infront of the date making it invalid!! how can i get ri dof the space? =/ it seems to put it there standard

You can use

=N(E3) or =--E3

to return the numeric value

EDIT but you should edit the code and prevent the problem from happening.