Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
171
Views
Topic starter
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?
Posted : 11/03/2023 6:03 am
I'm confused by what you are wanting, are you wanting 2 formulas? It would be easier to visualize if you can upload your expected result in your worksheet.
Posted : 11/03/2023 12:33 pm
Hello,
D1 = 2022-09-01
D2 = 2023-08-31
=IF(AND(TODAY()>=$D$1,TODAY()<=$D$2),1,0)
This looks very much as an exercise question. Hope I’m wrong.
Br,
Anders
Posted : 11/03/2023 7:01 pm
