Good afternoon All,
I am trying to auto populate cells within a date range specified. I have a start and end date (Column A and B) and then individual columns for each day. I need the day to show C if it within the date ranges. Please can someone help with this as I am at a total loss. I have attached a sample of the sheet.
Thank you.
Katie
you can use this formula
=AND($A2<=C$1,$B2>=C$1)
you will get a TRUE or FALSE
add an IF to get a different OUTPUT
or use the formula in conditional formatting to get a colour
SHOW C
is that put the letter C into the cell
=IF ( AND($A2<=C$1,$B2>=C$1) , "C" , "" )
i have changed the end date , so its can be seen on a small grid
also you had 2012 as the end date
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Use this formula for conditional format
Please Login or Register to view this content.
Last edited by popipipo; 03-15-2020 at 08:57 AM.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
That's perfect! Thank you so much.
you are welcome
Like the use of median, would never have thought of that , as it uses thes conditions
- When the total number of values is odd, the Excel MEDIAN function returns the middle number in the data set.
- When the total number of values is even, it returns an average of the two middle numbers.
I like that and how it works for a gantt chart
much easier
noted for future use - thanks
Last edited by etaf; 03-15-2020 at 09:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks