Assistance with Today() function returning correct value

		Microsoft Office Forums > Microsoft Excel > Excel
Assistance with Today() function returning correct value

FAQ

Thread Tools

Display Modes

03-07-2018, 10:02 AM

DaveWSinger DaveWSinger is offline

Windows 7 64bit Assistance with Today() function returning correct value

Office 2010 64bit

Novice

Join Date: Mar 2018

Posts: 3

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

	1.pdf (10.1 KB, 12 views)
	2.pdf (10.2 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIFS function is only returning partial results	rgauss	Excel	2	01-25-2017 01:26 PM
Sum Function over Today +/- 60 Days	gabeha	Excel	2	09-12-2014 01:13 AM
Form field calculation returning 2x correct result	Jschueller	Word	1	08-20-2013 01:51 PM
How do I auto-update the TODAY excel function within PowerPoint show presentation?	Powerpoint100	PowerPoint	0	02-12-2013 01:45 PM
Today's Date Function	freschij	Excel	3	02-11-2011 10:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 PM.