Thread: Insert Date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Insert Date

=IF(ISBLANK(D6),"",TODAY())

and format as date

On 13 Sty, 13:54, newguy wrote:
I am trying to figure out a simple formula that when a user inserts
his initials into a cell the cell next to it gets the date
corresponding to the day he filled out his initials. This is what I
have

=IF(ISBLANK(D6),"",Date)

Thanks