Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 54
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
 



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 12:48 AM.


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