Hi,

I want to evaluate some function based on dates. There will be a box containing some date.
eg.
in A1 box some date I will write
I want to write a function like if the date in A1 is before some date(fixed and hardcoded) then do arithmetic function, otherwise do something else.
Basically I need excel function to judge whether a date is before or after some given date.

How can I do that?