Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2023, 11:03 AM
MaineLady MaineLady is offline Creating a Date with a formula Windows 7 32bit Creating a Date with a formula Office 2013
Advanced Beginner
Creating a Date with a formula
 
Join Date: Sep 2014
Posts: 51
MaineLady is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-03-2023, 10:23 PM
ArviLaanemets ArviLaanemets is offline Creating a Date with a formula Windows 8 Creating a Date with a formula Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Code:
=iif(and(today() > date(year(today()),4,30), today() < date(year(today()),12,1)),"a","b")
Reply With Quote
  #3  
Old 05-03-2023, 11:15 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Creating a Date with a formula Windows 10 Creating a Date with a formula Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@arvi
I suppose you mean IF instead of IIF ?
__________________
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
Reply With Quote
  #4  
Old 05-04-2023, 02:17 AM
ArviLaanemets ArviLaanemets is offline Creating a Date with a formula Windows 8 Creating a Date with a formula Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Pecoflyer View Post
@arvi
I suppose you mean IF instead of IIF ?
Again!
Switching between different programs does this!
Reply With Quote
Reply

Thread Tools
Display Modes


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 with a formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft