Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
current week, current month, current year
is it possible (either via vba or some function in excel) to indicate where a
particular date falls (e.g. within the current week, current month, and current year)? looking to create a report that identifies records as falling into current week, current month (excluding those that fall within current week), and year to date (excluding those that fall within current week and current month). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
current week, current month, current year
If your date is in A1
Current Year if(year(A1)=year(today()),True,False) Current Month if(month(A1)=month((today()),True,False) Current week depends on when the week starts (Saturday, Sunday, Monday) for Sunday =if(And(A1=Today()-weekday(Today()),A1<Today()-weekday(Today())+6),true,false) "joemeshuggah" wrote: is it possible (either via vba or some function in excel) to indicate where a particular date falls (e.g. within the current week, current month, and current year)? looking to create a report that identifies records as falling into current week, current month (excluding those that fall within current week), and year to date (excluding those that fall within current week and current month). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current year and current week number | Excel Discussion (Misc queries) | |||
Year-to-date based on current month | Excel Discussion (Misc queries) | |||
input box default values (current month, year) | Excel Programming | |||
Show week number in current month | Excel Discussion (Misc queries) | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions |