Thread: Assistance with Today() function returning correct value
View Single Post
 
Old 03-07-2018, 10:02 AM
DaveWSinger DaveWSinger is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Mar 2018
Posts: 3
DaveWSinger is on a distinguished road
Default Assistance with Today() function returning correct value
Hi.
I have a formula in a cell =IF(O2>0,"COMPLETE",(TODAY()-K2+1)*H2)
As you can see in attachment 1.pdf If I put a money value in H2 it returns a value in L2 as 431,670.00
If I put the date as per 2.pdf the formula works perfect.

I am relatively new to formulas but I do know that it seems to be calculating from 1900 date.
Can anyone suggest a change to the formula that can show the correct value without having a date entered?
Attached Files
File Type: pdf 1.pdf (10.1 KB, 12 views)
File Type: pdf 2.pdf (10.2 KB, 10 views)
Reply With Quote