Excel date function

Page 1 of 1

1 Replies - 562 Views - Last Post: 24 November 2012 - 12:44 PM

#1 Aristo  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 02-December 05

Excel date function

Posted 24 November 2012 - 03:34 AM

Hi Guys,


I have an issue that I am trying to resolve with excel function.
Basically I have three columns and all I want is when a user insert a value into one of these columns, the days date is inserted into column B to record the day of insert.

I tried this function for one of the columns: =IF(B3<>"";IF(B3="";TODAY();B3);"") and it works fine. But I want to extend this for the rest columns, but cannot get it to work with the function below.

=IF(OR(D3<>"";IF(B3="";TODAY();B3);"";IF(OR(F3<>"";IF(B3="";TODAY();B3);"";IF(OR(H3<>"";IF(B3="";TODAY();B3);"")))


I would really appreciate your help guys....Thanks

Is This A Good Question/Topic? 0
  • +

Replies To: Excel date function

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 6464
  • View blog
  • Posts: 23,509
  • Joined: 12-June 08

Re: Excel date function

Posted 24 November 2012 - 12:44 PM

Please avoid duplicate topics. Closing.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1