|
|
#1
12-05-2010, 09:09 AM
|
|||
|
|||
Automatic calendar
The first of a month is put into A1
What formula can I put into C1, E1, G1, etc (ie alternate columns) which will give me the first of the following month? I cannot put =A1+31 because the month in A1 is not necessarily a 31 day month and there might be a leap year. (I am wanting to set up a calendar which is automatically set from whatever month is set in A1) 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Make Exchange calendar the default calendar
|
the-ninth | Outlook | 2 | 11-03-2010 10:41 PM |
| Macro for automatic sorting | Ziggy-R | Excel | 13 | 10-04-2010 06:57 PM |
|
Calendar invite - adding to personal calendar
|
nadall | Outlook | 1 | 09-01-2010 04:05 PM |
| Automatic bcc | nickynono | Outlook | 0 | 06-13-2006 02:30 PM |
|
Automatic email pop up
|
anitadzebic | Outlook | 4 | 03-09-2006 08:33 PM |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode