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
|