trying to to prevent -39904

Toshiba / Satellite l500
November 3, 2010 at 22:30:30
Specs: Windows Vista, 2 GHz / 2936 MB
I am using the following formula =DAYS360($D$1,$D3) in my excel sheet.
$D$1 - refers to the field that sheet gets the date from the system using.
$D3 - refers to a static date that is entered manually

My issue is if there is no date entered into $D3 the formula spits out -39904 and grows by 1 everyday that passes since it was created.

I am need help to get it to not run the formula =DAYS360($D$1,$D3) if $D3 is empty. I have tried various different methods most recent one being the following formula: =IF($D11=" ", " ", DAYS360($D$1,$D11)). I can't seem to find anything that works, can someone pls help.

Yes i also understand that i can just remove the formula for unused cells but i am trying to make it so that if someone else has to use it they don't screw it up by trying to copy the formula to where they need it on the sheet.

I have come up the with the following formula: =IF($D12=0,$E12=0,DAYS360($D$1,$D12)), that would makes the value no longer the negative and just puts a zero there. If you can help me figure out how to make it just leave the cell blank of the other

See More: trying to to prevent -39904

Report •

November 4, 2010 at 01:33:53
I figured out the formula i needed was =IF($D8=0, " ",DAYS360($D$1,$D8)). I provided this information incase anyone else is having a similar issue/difficulty.

Report •
Related Solutions

Ask Question