Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2008 Julian Callendar
How do I have repeat meetings fill all the other months when I enter it once
in Jan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2008 Julian Callendar
Sandy wrote...
How do I have repeat meetings fill all the other months when I enter it once in Jan Excel isn't a calendar organizer, but it can be made to do such things. However, different people's approaches may (and almost certainly do) differ. So without details from you, impossible to give a detailed answer. In generalities, if cell C3 contained a date you wanted to repeat in every other month of the same year, the formula =DATE(YEAR(C3),MONTH(C3)+n,DAY(C3)) would return the same day of the month n months after the date in C3 as long as DAY(C3) <= 28. Or, if you have the Analysis ToolPak loaded, you could use =EDATE(C3,n) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
6/30/2008 date error?! | Excel Discussion (Misc queries) | |||
NCAA Basketball Bracket 2008 | Excel Discussion (Misc queries) | |||
Update 2007 calendar to 2008 | Excel Discussion (Misc queries) | |||
Callendar to date? | Excel Discussion (Misc queries) | |||
How to calculate number of month from 2008 in Excel? | Excel Discussion (Misc queries) |