good evening
cell A1 has any data
cell B1 is my conditional formula
which is if I have number in A1
then B1 will disply today's data
the formula is:
=IF(ISNUMBER(A1),TODAY(),"")
until now it's working fine, but next day
date will be changed, I want this date to be fixed
I tried now instead of today
but still date is changing
anyone can help
thanks in advance
Bookmarks