#1
|
|||
|
|||
If date is Current Month 1 or within 30 days
I have an "if" statement to enter number 1 in column B if the date is in the current month. Works great, but limiting. I still want to count dates within the current month but also count if it is within 30 days out of todays date. So current month and +30 days out make it a 1 in column A.
I am trying to esitmate capacity for the team by identifying projects that will close within 30 days by the date entered in column A. Thoughts? |
#2
|
|||
|
|||
When Date is within 30 days, In30=1, otherwise 0
|
#3
|
|||
|
|||
Thank You!
Thank you for a quick response and solid answer. There isone missing element though is I want to include all dates within the activemonth as 1 also. So far your example the +30 as well as all dates in September.This allows the team members some time to close out there projects as completefor the month as I also have a filter set for all projects in-progress. =([@Date]>=TODAY())*([@Date]<TODAY()+30) To achieve what I wanted required me to do a 3 step processthe range dates:
Any thoughts on how that could be combined as a single formula/singlecolumn |
#4
|
|||
|
|||
Like
Code:
=([@Date]>=TODAY())*OR([@Date]<TODAY()+30,MONTH([@Date])=MONTH(TODAY())) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate amount of days per month from a given timerange | Yde1203 | Excel | 3 | 05-02-2019 08:13 PM |
Configure for 30 days, not calendar month | teapea21 | Outlook | 1 | 07-31-2014 09:05 AM |
Formula to divide if no of days in month is 28 | shilabrow | Excel | 5 | 06-26-2014 12:17 AM |
Date Field to add 10 Days to Current Date | Erbwon | Word | 6 | 11-12-2012 06:17 PM |
Auto insert current month's name and current year | Styler001 | Word | 4 | 01-25-2010 06:40 PM |