Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing Excel -> Outlook Calendar | Excel Discussion (Misc queries) | |||
how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How would I make a calendar template in Excel for the year 2006?? | Excel Worksheet Functions | |||
Pop up calendar won't show in Excel 2000 | Excel Discussion (Misc queries) |