i am using this formula :
=IF(A1>TODAY();TRUE;FALSE)
but not working if A1 date format is Hijri date
i am using this formula :
=IF(A1>TODAY();TRUE;FALSE)
but not working if A1 date format is Hijri date
Hi,
The format in which a date is displayed does not matter. What matters is that the date number is a valid Excel date number. e.g. today's number is 41902.
What do you actually have in the A1 cell?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
A1 is 25/11/1435
thank you for reply but i search for formula not macro
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks