LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Randy
 
Posts: n/a
Default Set up a Calendar in Excel

I have a Lotus 123 spreadsheet that brings up three calendars. I need
to convert it to EXCEL. All I do is enter the first date of the month
and the three months come up one under each other. I just used
formulas to create the dates in each field.

Could someone tell me a formular I could use in the cells to bring up
the appropriate days for each calendar.

I tried to just convert the spreadsheet and apparently there is some
problem with the formula.

Here is the 123 formula for the 1st day of the month of the first
calendar. I just added days to it to get the rest of the days of the
month.

@IF(H70,H7+1,@IF(@DATEINFO(@DATE($A7,$A8,1),3)=R$ 1,1,""))

I need a formula that will work with Excel.

Thanks for any help.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Excel -> Outlook Calendar rsawalker Excel Discussion (Misc queries) 1 July 5th 05 07:15 PM
how do I adjust working calendar (6 day work week) in excel that . Hatem Excel Worksheet Functions 1 January 25th 05 12:04 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
How would I make a calendar template in Excel for the year 2006?? GHL Excel Worksheet Functions 5 January 21st 05 07:05 PM
Pop up calendar won't show in Excel 2000 Juls Excel Discussion (Misc queries) 1 January 6th 05 08:40 PM


All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"