
Automatic setting of desired dates

lea cohen
Posts: 219

March 10, 2023 - 8:03 pm
1
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?

Is viewing
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Andy Kirby, Scott Miller, Lawrence Smith, Shawn Barwick, Ivica Cvetkovski
Guest(s) 9
Currently Browsing this Page: Ivica Cvetkovski
1 Guest(s)
1 Guest(s)
Devices in use: Desktop (12), Phone (2)
Forum Stats:
Groups: 3
Forums: 24
Topics: 6203
Posts: 27199
Member Stats:
Guest Posters: 49
Members: 31875
Moderators: 3
Admins: 4