Automatic setting of desired dates|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi, thanks for the help
I have attached an excel file
define a condition function
Is the date greater than 1/9/22
Is the date small - 1/8/23
If so - write 1 | If not - write 0


These dates represent the beginning of the Hebrew year and the end date of the Hebrew year
Right now the dates are written on the side and I need them to be accepted as part
of the formula and I won't have to type them in external cells

I need to base it on the Today function
That is, for each current day - you will display the start date of the Hebrew year and the end date of the Hebrew year
How do you do it?