inside cell a30 i have a date function which displays:
Mon 07/22/2013 3:30:14 AM. i realize that excel actually uses 41477.146
Can i search for something kin the display, i.e. "Mon"?
inside cell a30 i have a date function which displays:
Mon 07/22/2013 3:30:14 AM. i realize that excel actually uses 41477.146
Can i search for something kin the display, i.e. "Mon"?
Why dont you follow the same display logic..
something like..
=search("Mon",text(A1,"ddd mm/dd/yyyy hh:mm")
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Maybe..
=TEXT(D5,"ddd")="mon"
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks