|
|
#1
05-03-2023, 11:03 AM
|
|||
|
|||
Creating a Date with a formula
I have a spreadsheet in which I want to make a choice of "A" or "B" based on a set of dates - i.e.,
If today is >4/30/current year and <12/1/current year, choose "A" else choose "B" Is there a way to write a formula for this? Thank you, Thank you, Thank you - in advance 
|
|
#2
05-03-2023, 10:23 PM
|
|||
|
|||
|
Code:
=iif(and(today() > date(year(today()),4,30), today() < date(year(today()),12,1)),"a","b")
|
|
#3
05-03-2023, 11:15 PM
|
||||
|
||||
|
@arvi
I suppose you mean IF instead of IIF ? 
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
05-04-2023, 02:17 AM
|
|||
|
|||
|
Quote:
 Switching between different programs does this!
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating a date that is referenced throughout the document | Speakeasy | Word | 7 | 02-03-2021 09:10 AM |
| Formula for looking at 1 cell with a date and then comparing it to four date ranges | LearningMom | Excel | 3 | 10-27-2017 12:44 PM |
| Please help me with creating due date field | Artemio | Word | 1 | 03-01-2012 08:10 PM |
 Creating a date box
|
Philip290 | Excel | 5 | 05-11-2011 03:27 AM |
| Help with creating a Formula, please | websiteaog | Excel | 9 | 11-25-2010 04:09 AM |
Windows 7 32bit 
Office 2013
Linear Mode
