=(B3-TODAY())*2000
this should yield a negative value because 'Today()' will alway be larger than any previous date.
the correct form should be
=(TODAY()-B3)*2000
=(B3-TODAY())*2000
this should yield a negative value because 'Today()' will alway be larger than any previous date.
the correct form should be
=(TODAY()-B3)*2000
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks