What I’m trying to do is if the letters NMC are in cell H10 I want cell I10 to insert today’s date or have a message pop up asking you to insert a today’s date in that cell
What I’m trying to do is if the letters NMC are in cell H10 I want cell I10 to insert today’s date or have a message pop up asking you to insert a today’s date in that cell
It could be
=IF(H10,TODAY(),"")
But remember TODAY is volatile, ie it will update automatically
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
That help out, this is the formula I have now =IF(H10= "nmc",TODAY(),"") is there any way to get it to calculate the date only once and not daily?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks