Please confirm you want to mark all posts read
Automatic setting of desired dates
March 10, 2023 - 8:03 pm
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?
March 11, 2023 - 2:33 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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Andy Kirby, Scott Miller, Lawrence Smith, Shawn Barwick, Ivica Cvetkovski
Currently Browsing this Page: Ivica Cvetkovski
Devices in use: Desktop (12), Phone (2)
Guest Posters: 49