IF() system date not yet reached (compare with future date)

[vba_php]

I'm so sorry guys, I know this is simple stupid. but the interface doesn't have dateSerial(), as I see. so, here's what I have. I have this data:

FEE	FEE END DATE
$0	1/18/2022

what I need is a function in the FEE column whereby the $0 is always displayed until the date 1/18/2022 is reached, and after that point, $25 is displayed. can someone help me out with the formula? thanks. the check is based on my windows OS data/time stamp set. it is reading the atomic clock in Denver

[AliGW]

Something like this?

=IF(TODAY()<B2,0,25)

where B2 is the cell in the fee end date column that shows the end date.

[bebo021999]

With date in B2:
In A2:
=(B2>DATE(2022,1,18))*25
Is it are you looking for?

[vba_php]

both work fine guys. thanks. sorry for the simplistic nature. obviously I know nothing about simplicity.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[vba_php]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

I think you're going to have to remind me to do that until the day I die. he he. done. thanks.

[AliGW]

I hope not!